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