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;
Password=manager;"

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.

eg.
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

HI
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 http://www.developersdex.com ***
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

3. SET SCHEMA?

4. Set schema="yourdb"

5. Cannot set SCHEMA in db2cli.ini

6. set schema in visual explain...

7. SET SCHEMA?

8. Set schema="yourdb"

9. Set Schema problems

10. "set current schema" and commit

11. DateTimeFormat Schema setting


 
Powered by phpBB® Forum Software