0 Replies Latest reply: Oct 11, 2006 10:41 AM by 538930 RSS

    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, 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,