Setting Schema 
Author Message
 Setting Schema

One option you have is to log as the user you are using to
connect to Oracle and create a synonym:

CREATE SYNONYM tblSamp FOR dsdh.tblSamp

Hope it helps.

Lufe

Quote:
>-----Original Message-----
>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.
>.



Sun, 27 Jun 2004 03:51:34 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Set Schema problems

2. Setting schema

3. Set schema="yourdb"

4. set schema in visual explain...

5. SET SCHEMA?

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

7. SET SCHEMA?

8. Set schema="yourdb"

9. Cannot set SCHEMA in db2cli.ini

10. Set current-schema and granting

11. How to set a Schema programmatically for Xerces-j

12. SET CONSTRAINTS not schema-aware


 
Powered by phpBB® Forum Software