ODBC to Oracle (table or view does not exist)

I've reached the limit of my knowledge here and I'm starting to go mad
- any help would be greatfully recieved!!!!

I'm having a strange problem with making pass through queries to an
oracle db with a permament connection string.

- if i create the passthrough query by writing the sql into the sql
builder window and selecting the connection details on opening the
query then everything works fine

- if i run the query in SQL*Plus with the same login details everything
works

- if i create an ado rst using the same connection details it works
fine

However if i create the query and specify the connection string - it
fails:
ODBC--call failed.
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist
(#942)

opening the query in design mode and replacing the sql with "SELECT *
FROM ALL_TABLES" (i.e. same connection string, but different sql)
connects and runs, but only reveals 33 tables - none of which are the
ones I need to connect to.

Here's the sql used to build queries (p'words etc removed):

qDef.Connect = "ODBC;DSN=*******;DBQ=******;UID=*******;PWD=******;"
db.QueryDefs.Append qDef

Even weirder still - if i used the linked table ODBC wizard, I can link
to the table - but when I attempt to open it I get the same message. It
appears even Access itself is not getting the connection string
correct.

I'm only new to this oracle thing ...does anyone have any idea what's
going on here?

.

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Invalid field size"
    ... I'm using just the ADOQuery component and a CONNECTION STRING, ... When I query a record that exists, the requested fields in the SQL are ... Not long ago MySQL/ODBC had this problem with CHAR() fields smaller ...
    (alt.comp.lang.borland-delphi)
  • Re: Could a change of SQL ports break a data reader?
    ... Can you use SQL Profiler ... to catch the statement that gets executed, paste it into query ... > Dim connectionString As String ... > ' now we have a valid connection string ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ODBC to Oracle (table or view does not exist)
    ... ODBC driver version match version of Oracle db? ... if i create the passthrough query by writing the sql into the sql ... However if i create the query and specify the connection string - it ...
    (comp.databases.ms-access)
  • Re: ODBC to Oracle (table or view does not exist)
    ... Try prefacing the table names in the pass-thru SQL with the schema name: ... if i create the passthrough query by writing the sql into the sql ... builder window and selecting the connection details on opening the ... However if i create the query and specify the connection string - it ...
    (comp.databases.ms-access)