0 Replies Latest reply on Jun 18, 2008 3:24 PM by jdlandry-Oracle

    Receiving OraOLEDB error '80040e14'

    jdlandry-Oracle
      An aquaintance has ASP code that has been in place for several years and has never had a problem with it, so they are wondering whether something has been pushed on the network that is shutting down his access.

      His Oracle queries are made from an asp page. In each asp page that executes a query, a connect file is included.

      The connection file includes the following connection information:

      Dim objConn
      Dim strConnection

      'Create database connection to ACES_LOCAL Oracle server
      Set objConn = Server.CreateObject("ADODB.Connection")
      trConnection = "Provider=OraOLEDB.Oracle;Data Source=gvisionpro;User ID=aces_interface;Password=xxxxxxxxx;PLSQLRSet=1;"
           objConn.Open strConnection

      The error he's getting is:

      'Create SQL statement and retrieve records for selected installation-facility str_sql = "select WONR,FACIDNR,TYPESVC,WOTITLE,PROJNBR,WOSTATUS,TRKIND,REQNAME,PHONE,DATEOPEN " str_sql = str_sql & "from WOBYFAC where FACIDNR= " & RIDV & " order by WONR " Set dbrec = Server.CreateObject("ADODB.RecordSet") dbrec.open str_sql, objConn, 3, 3 if dbrec.bof = true and dbrec.eof = true then 'Dont use the movefirst method on an empty recordset
      OraOLEDB error '80040e14'
      ORA-00936: missing expression
      /geobase/hyperlink/IWMS.asp, line 39

      A. He can connect and execute the query using SQLplus
      B. The database is oracle 9i
      C. His asp code has not changed in several years and was working until last Thursday
      D. He tried a simple query on a different database (this one 10g) using the same type of connection and got the following error:

      OraOLEDB error '80004005'
      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
      /geobase/Connections/objOracleConn2.asp, line 11

      Any ideas, suggestions etc would be greatly appreciated