Forums: [SOLVED] Oracle ODBC Errors - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

[SOLVED] Oracle ODBC Errors Cannot connect to Oracle via ODBC Rate Topic: -----

#1 User is offline   cbellar 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 3
  • Joined: 10-January 06

Posted 10 January 2006 - 10:41 PM

Hello,

I am getting Oracle connect errors using the following drivers:

Oracle InstantClient: Specified driver could not be loaded due to system error 1114 (Oracle in instantclient10_2).

Microsoft ODBC for Oracle: [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
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 16322
  • Joined: 03-February 03
  • Gender:Male

Posted 11 January 2006 - 01:42 PM

Cleve,

please make sure you follow all steps described at:
http://www.xlinesoft...tm#oracleerror5

This must be a permissions issue.
Best regards,
Sergey Kornilov
0

#3 User is offline   cbellar 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 3
  • Joined: 10-January 06

Posted 12 January 2006 - 06:23 PM

View Postadmin, on Jan 11 2006, 07:42 AM, said:

Cleve,

please make sure you follow all steps described at:
http://www.xlinesoft...tm#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
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users