ASP - SQLAllocHandle error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQLAllocHandle error

karan

2004-03-28, 9:57 pm

Hi I am trying to make a simple connection in an asp page (oracle)
Dim DConnect
Set DConnect = Server.CreateObject("ADODB.Connection")
DConnect.Open "dsn=mydata;uid =xyz;pwd=xyz"
DConnect.Close
Set DConnect = nothing

I am getting this error.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_ENV failed
I have made the dsn using Microsoft ODBC for Oracle 2.573.9030
I am running windows 200 server, I have tested the dsn using 'oracle
odbc test' utility. i can connect to the database and can run the
queries.

But gives the above error from my asp page,Please suggest any
solution.
Thanks.

Sponsored Links