I have an issue here. Have a web server running IIS 5 on windows 2000
advanced server. The application connects to a database running Oracle
9i. I have an Oracle home directory and Oracle components installed on
web server. Using sql plus I can connect to db. The tnsnames file is
same tnsnames file across the network on local machines. Have set up a
DSN on the webserver for connecting to db using Microsoft ODBC for
Oracle Driver. I can write app in Vb using the DSN and connect to db.

The web page we have has a login in screen. After entering
username/passowrd combo the following error is generated.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle][ORA-12154: TNS: could not
resolve service name.

Again I can write a VB app on the server and using the same DSN record
I can connect. It resolves the TNS name. Here is entry in tnsnames.ora
file


HADD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= oraapps1)(Port= 1523))
(CONNECT_DATA = (SID =HADD))
)

DSN entry for the ODBC connection has
DataSource Name: Hadd
Username: apps
Server: oraapps1.

The connection in the asp code is as follows:
MM_hadd_String = "dsn=hadd;uid=apps;pwd=apps;"


This is happening now and last week the web page loaded and behaved
like expected. No changes have been made since then.
I would appreciate any help anybody has.