Oracle DSN 1

[beruken]

I have a DSN connection to an Oracle DB. I can connect to the Database no problem but when I try yo reference a particular table in my query I get the message

"TABLE OR VIEW DOES NOT EXIST"

Set oOracle = WScript.CreateObject("ADODB.Connection&quot
oOracle.Open "FileDSN=Luf.dsn;UID=hunt;PWD=changeme"
Set oRst2 = WScript.CreateObject("ADODB.Recordset&quot
sQuery = "SELECT * FROM MGR_ACCT WHERE acct_id LIKE '2EX8A%'"
oRst2.Open sQuery, oOracle

I know the table names and fields are spelled properly since I can connect through MS Access's "linked tables" feature and see all the tables and records.

Any Ideas Why?

Thanks

 

[THoey]

Does "hunt" own the objects? Does "hunt" have SELECT priviledges? Try a different query (SELECT SYSDATE FROM DUAL to verify that you are really attached to the DB. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[beruken]

SELECT SYSDATE FROM DUAL WORKED! Yes Hunt has access to the objects. As I said I can open a linked connection to the DB and tables in Access 2000.

 

[Turkbear]

The issuse is not just 'access to the objects' but ownership
of the objects... In Oracle a table has a 2 part name:
schema.tablename
So, if hunt does not own ( that is, if it is not in his schema) the table you need to specify the schema as well as the tablename ; so, if SCOTT ( for example only) owns
MGR_ACCT, you would need to specify SCOTT.MGR_ACCT when querying...

hth