Drivers error'80004005'

From: <tlc27_at_my-deja.com>
Date: Wed, 08 Sep 1999 21:05:17 GMT
Message-ID: <7r6j22$3ai$1@nnrp1.deja.com>

This application connects to three Databases: ACCESS, SQL Server and Oracle(Tivoli). Everything used to be working fine when the webs retrieve information back or forth to Tivoli database. Right now each time when web app tried to talk to Tivoli, it gave me this error msg:

	"Microsoft OLE DB Provider for ODBC Drivers error'80004005'
	 [Oracle][ODBC][Ora]Error while trying to retrieve text for

error ORA-12154"

	ORA-12154 means that "Couldn't resolve the service name"
	We checked the ODBC set up in the BHIESTWEB01. The

configuration looks correct and in MS Access , we could link the oracle tables to it. We ran "Oracle ODBC test", it worked properly. We also checked the TNSNAMES.ORA file, the service name and description all are correct. SQL*Plus is working when communicate with Tivoli.

        On the web side, It used to work, and, the app could query and update to SQL server DB and Access DB. All of these means that the code has no problems?!? Yes ?

        In the old web, this web page works exactly as what we want.

        So, I think it might be the file permission or other security setup has been preventing the web from accessing the ODBC. Any advice will be greatly appreciated!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 08 1999 - 16:05:17 CDT