Trouble connecting from an ASP

Our application connects to Oracle 7.3.4 from Active server pages using ODBC and ADO 1.5. We are currently using the Microsoft ODBC 2.73.728301 drivers since the Oracle drivers don't work for some of our processes. The scripting language we are using in the ASP pages is mostly Javascript, although we use VB script where Javascript won't work.

Sometimes the first connection to the DB fails and I am completely unable to run the application. The script error message is pretty useless:

error 'ASP 0115'

Unexpected error

/adante/Default.asp

A trappable error occurred in an external object. The script cannot continue running

Sometimges I have gotten this message although it could be a result of the system getting into a wierd state due to previous errors:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-03121: no interface driver connected - function not
performed

Other symptoms
1. Rebooting does not help. In fact it can cause the problem to recur after the program was running well.
2. Sometimes running an ADO test page appears to have helped. The page just connects to the DB and does a simple query. After connecting I can run the application normally. 3. After the application fails inetinfo.exe will start hogging the CPU and I can't even kill it in TaskManager. I have to reboot to stop it. 4. The problem does not occure using the same with MS SQL server

Any ideas on how to debug this thing? Of course exact understanding of the solution, or even the cause of the problem would be gratefully accepted, but I'm afraid that is a bit too much to hope for. Any ideas would be welcome.
Rob Crockett
Robert.Crockett_at_forteinc.com Received on Tue Jun 16 1998 - 17:26:58 CDT