Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ASP to Oracle connection problem
On 14 Apr 2007 22:34:52 -0700, rajpat13_at_gmail.com wrote:
>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.
It has nothing to do with Oracle, as there is no Oracle error message.
Usually using Microsoft drivers for Oracle results in all kind of
problems.
Either visit a Microsoft newsgroup or use the ODBC driver of Oracle.
Sybrand Bakker
Senior Oracle DBA
Received on Sun Apr 15 2007 - 06:53:19 CDT