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