ASP and Oracle Issues

Hi, I am using IIS 4.0 in Windows 2000 Professional. I am connecting to an Oracle 8.1.7 Server running in Windows NT. ASP Code connects and works fine for 1 or 2 hours after that it is giving me Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Oracle][ODBC][Ora]Error while trying to retrieve text for error ORA-12154 When I Stop and Start my IIS Service then it seems to work for another hour or 2. When I saw the Event Log I found out this error is occuring when the connection between my ASP and Oracle is broken. Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 37 Out of process application '/LM/W3SVC/1/Root' terminated unexpectedly. I tried using Oracle ODBC Driver and Oracle OLEDB both are behaving the same. Whoever helps me to solve this isuue will be awarded quicker solution will get bonus. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform IIS, WEB, ASP, Oracle