ASP to Oracle connection problem

From: <rajpat13_at_gmail.com>
Date: 14 Apr 2007 22:34:52 -0700
Message-ID: <1176615292.642076.300170@w1g2000hsg.googlegroups.com>

Hello friends,
I have installed Oracle 9i Client and database on my laptop which has Windows XP Media Center. I am getting following error message when I try to connect to Oracle database from ASP:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

I have following connection string:
strConn = "Driver={Microsoft ODBC for Oracle}; ConnectString=myServer; UID=user; PWD=password"

I can access the database from command prompt using sqlplus user/ password_at_myserver. So, my database and client are installed properly. Other people also had similar problem but I could not find a solution. Please advice.
Kind regards,
Raj. Received on Sun Apr 15 2007 - 00:34:52 CDT