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

Home -> Community -> Usenet -> c.d.o.server -> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

From: <shadow1100_at_my-deja.com>
Date: Mon, 26 Jul 1999 19:15:50 GMT
Message-ID: <7nic4u$rhr$1@nnrp1.deja.com>


I can't seem to find an answer to this:

   oConn = Server.CreateObject("ADODB.Connection");    oConn.Open ("sys_dsn")

    yields:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

I looked up some prior post which talk about SQL*Net being installed. I'm able to connect to the DB via SQL Plus - does this tell me I've got SQL*Net installed properly?

When create a Conection object in VI, I can view the DB tables/views via dataview (although I get a message box with an ADO error first)

Attempting to connect to Oracle 7.3 via ADO Microsoft ODBC 2.573 4202.00
Windows 95; Personal Web Server

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 26 1999 - 14:15:50 CDT

Original text of this message

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