ODBC and IIS for Windows XP

[tmcneil]

I have an ASP web app. that uses an ODBC connection to Oracle 9i. I've setup an ODBC connection pointing to my oracle DSN and my TNS service name and tested the connection successfully. I've also added the IUSER_ and IWAMS_ accounts to the C:\oracle\ora92 folder to make sure that IIS can access the oracle libraries. So, why do I still get this error when I try to load my login.asp page?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 5 (Oracle in Oracle9i).
/stlpacis/include/database.asp, line 65

The block of code causing the error is this:

Function GetDBConnection
	Dim conn
	Const adOpenStatic = 3
	Const cConnection = "DSN=stlpacis;UID=stlpacis;PWD=stlpacis;DATABASE=stlpacis;APP=ASP script"

	Set conn = Server.CreateObject("ADODB.Connection")
	conn.ConnectionString = cConnection
    conn.CursorLocation = 3 '* adUseClient
    conn.Open
    Set GetDBConnection = conn
End Function

So, what am I doing wrong?

Todd

 

[Turkbear]

Hi,
Why not use Oracle's OLE DB provider ( with no ODBC, none is needed)to insure compatiblilty?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[tmcneil]

Turkbear,

The code is already written for this app. I am trying to configure it to work on a new laptop for travel. So, I can't just rewrite the code when the customer is already using it the way it's written currently.

Todd