Re: Oracle 8i and ODBC connection problem

So, I figured out the problem, but can someone answer this?

Server#1 has the following connection line:

set my_conn=Server.CreateObject("ADODB.Connection") conn.Open "ODBC name here", "username here", "password here"

This does not work on Server #2 and I get the following:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

/ServerB14/detail.asp, line 85

However, when I changed the connection line in ASP to:

set my_conn=Server.CreateObject("ADODB.Connection")

   conn.Open "Driver={Microsoft ODBC for Oracle};" & _

"Server=ODBC name here;" & _
"Uid=username;" & _
"Pwd=password;"

It works

Any thoughts as to why this is happening and how I can correct this so that I don't have to make individual asp corrections to my backup Server everytime?

Server #1 is running IIS5/Windows 2000 and Server #2 is running WindowNT 4.0 SP6 with IIS4 Received on Sun Mar 04 2001 - 22:46:07 CST