Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ASP to Oracle connection problem

Re: ASP to Oracle connection problem

From: <sybrandb_at_hccnet.nl>
Date: Sun, 15 Apr 2007 13:53:19 +0200
Message-ID: <he44231da742cqmo5pnkov9oc85ko93oqe@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US