Re: SQLAllocHandle Errort
From: Bernard (qbernard_at_hotmail.com.discuss)
Date: 03/17/04
- Next message: Bernard: "Re: FTP Accounts"
- Previous message: Bernard: "Re: IIS - Documents - "Default Document may not contain a path"-Error"
- In reply to: karan: "SQLAllocHandle Errort"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 17:02:10 +0800
Not sure but,
a) try update latest driver
b) try not to use DSN, refer
http://www.aspfaq.com/show.asp?id=2009
-- Regards, Bernard Cheah http://support.microsoft.com/ http://www.msmvps.com/bernard/ "karan" <kabi_240@hotmail.com> wrote in message news:72d090e3.0403162043.2d058283@posting.google.com... > Hi I am trying to make a simple connection in an asp page > 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.
- Next message: Bernard: "Re: FTP Accounts"
- Previous message: Bernard: "Re: IIS - Documents - "Default Document may not contain a path"-Error"
- In reply to: karan: "SQLAllocHandle Errort"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
