ODBC error

[manutektips]

Hi,
I am getting this error when I tried to connect to Oracle 9i database from an asp application. The error is "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed ". The connection string I am using is : "DataConn.Open "Driver={Microsoft ODBC for Oracle};Server=& servername & ";Uid=" & userid ";Pwd=" & password".

Please help

 

[dbtoo2001]

DataConn.Open "Driver={Microsoft ODBC for Oracle};Server=& servername & ";Uid=" & userid ";Pwd=" & password".

I would look at the number and placing of the ' " 's.