Tuesday, 3 September 2013

how to set schema in ado.net after open the connection

how to set schema in ado.net after open the connection

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'
Please tell me
srinivasp

No comments:

Post a Comment