Hi
Iam connecting to db2 database i have a problem that i will going to schema in after connection opening
i want to set the schema
iam connecting to the db2 database in this database different schemas are there.
I want to connect to connect particular schema only,
i tried that in connection string we cant give the schema,
After connection opening only we have to set the schema,
i have a code that i.e by using connect to the active data object(ADO) only,
but in ado.net how to give i dont know
Below is the code for ado connection
db.Open DBcon_string
db.Execute ("SET SCHEMA=" & AppSchema)
db.Execute ("SET PATH=""SYSIBM"",""SYSFUN"",""SYSPROC"",""SYSIBMADM"",""" & AppSchema & """")
Note: db is adodb.connection
Replace AppSchema with ‘ETWRMS’
srinivasp