I have an .asp page that writes to my Oracle DB, and on one server (WB) it works great, on the other (RT) I receive the following error about 50% of the time:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Execute'
/SolutionsT/course_startIns.asp, line 88
The code is fine - I've had several "experts" check it out. And it works fine on the WB server all the time.
I checked the ODBC on both servers, and the only difference I can find is that RT uses the Microsoft ODBC Driver
2.573.7713.00 and WB uses the Microsoft ODBC Driver 2.573.7926.00
I am not sure if this could be causing the problem or not...
The coding reads like this:
dim objSQLDB, rsEDPersons, strSQL, repeat
Set objSQLDB = Server.CreateObject("ADODB.Connection")
strSQL = "Select empid from ED_PERSONS where empid ='" & empid & "'"
Set rsEDPersons = objSQLDB.Execute(strSQL) //line88
Technical Business Analyst