VB+ODBC problem

[Mr Grain]

Hello all,

I'm having a problem connecting to an Oracle table using DAO and a
DSN.

The connection works ok.

But I keep getting the error "3184 - Could not execute query - could
not find the linked table." - when I try to open a recordset.

However, using the Oracle ODBC 32 bit tester, I can run the query
against the DSN that the recordset uses without a problem, rows are
returned as normal.


The code I'm using at the moment is simple, as folows.

Set ws = DBEngine.Workspaces(0)

strConnection = "ODBC;DSN=AIRE_CAP1;UID=********;PWD=******"

Set db = ws.OpenDatabase("", False, False, strConnection)

Set thisRec = db.OpenRecordset("select * from system_avail;")

Does anyone know why this is? It used to work before.

[Geffa]

Re: VB + ODBC

I recall there being an issue with DAO3.6 and Oracle databases regarding case sensitivity of the table name you are selecting from.

Try changing it to upper case and have another go.

Good Luck