This topic is locked
[SOLVED]

 Oracle ODBC Errors

1/10/2006 5:41:37 PM
ASPRunnerPro General questions
C
cbellar author

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

admin 1/11/2006

Cleve,
please make sure you follow all steps described at:

http://www.xlinesoft.com/asprunnerpro/faq.htm#oracleerror5
This must be a permissions issue.

C
cbellar author 1/12/2006

Cleve,

please make sure you follow all steps described at:

http://www.xlinesoft.com/asprunnerpro/faq.htm#oracleerror5
This must be a permissions issue.


It was permissions, but in a different way. I had setup my Oracle path via my User Environment Variables vs using System Variables. So, IIS could not see it.
May be something else to add to the list....
Thanks!

Cleve