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:
'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;"
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