Hello,
I am getting Oracle connect errors using the following drivers:
Oracle InstantClient:
Microsoft ODBC for Oracle: [color=#FF0000][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I get the same error whether I use a DSN or connect straight with the driver.
I have run through the other hints verifying that I granted "authenticated users" read and write access to the the OracleInstantClient home. I even made my anon IIS user an admin. No luck.
By the way, I can connect via ODBC from various SQL tools without issue and can of course see the tables when building the ASP pages via the tool.
Here are the two different connect strings:
<%
strConnection = "DRIVER={Oracle in instantclient10_2};SERVER=CAOSODST;UID=login;PWD=password;DBQ=CAOSODST;DBA=W;APA
=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccess
ful;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;"
%>
<%
strConnection = "DRIVER={Microsoft ODBC for Oracle};UID=login;PWD=password;SERVER=CAOSODST;"
%>
Thanks!
Cleve