Setting schema 
Author Message
 Setting schema

I have been using the below connection string to connect
to an Oracle DB. Which the connection works ok.

"Provider=MSDAORA;Data Source=sog4;User ID=system;

The only problem is when I go to use SQL select statements
to select data from a particular table the scehma name is
needed to find the table.

SQL Statement A
Select * from tblSamp --Incorrect No Schema

SQL Statement B
Select * from dsdh.tblSamp --Correct with Schema

It is possible to set this scehma value as a default in
the ADO connection so that the SQL Statement A works.

Sat, 26 Jun 2004 13:00:42 GMT
 Setting schema

Check MSDN documentation for "OpenSchema" Method and "DefaultDatabase"
Property of ADO connection object.
Hope it helps.

Harinatha Reddy Gorla
        Software Engineer
Smart Software Technologies,
Hyderabad, India

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!

Sat, 26 Jun 2004 14:02:01 GMT
 [ 2 post ] 

 Relevant Pages 

1. db2 7.1/win2k - SET SCHEMA failure with JDBC

2. Setting Schema


4. Set schema="yourdb"

5. Cannot set SCHEMA in db2cli.ini

6. set schema in visual explain...


8. Set schema="yourdb"

9. Set Schema problems

10. "set current schema" and commit

11. DateTimeFormat Schema setting

Powered by phpBB® Forum Software