Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
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