Help connecting to Oracle via ADODB in MS Access 2003
I'm attempting to use vb within Microsoft Access to return a recordset.
I can connect, but I when I execute my select statement, I get the following message:
Run-time error '-2147217865 (80040e37)':
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist.
I've doublechecked the tablename in the select statement, and it is good. I've run the select statement directly from Access - using a linked table within Oracle, and it runs fine.
I'm using Oracle Net Manager 10.2.0.0.0, and my ODBC driver is "Oracle in OraClient10g_home1" My OS is XP SP2
Here is the connection (details obscured) info I'm using: Note. I don't get the error until I open the recordset.
strConnect = "Driver={Microsoft ODBC for Oracle};Server=myoradb;Uid=userid;Pwd=pass;"
sql = "select * from TABLE where SOMETEXTFIELD='sometextvalue'"
Set conn = CreateObject("ADODB.Connection")
Set rsSizing = CreateObject("ADODB.Recordset")
conn.open strConnect
rsSizing.open sql, conn, 3, 1
Any help would be much appreciated,
Joe