Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » connect to oracle 9i database in asp.net
connect to oracle 9i database in asp.net [message #182147] Thu, 13 July 2006 04:58
Messages: 1
Registered: July 2006
Junior Member

I am new to Oracle and am trying to connect to an Oracle 9i database from an ASP.Net web page. I have installed the Oracle client and am using TOAD for db admin type stuff. I can verify that the tnsnames.ora file is valid because I can successfully connect to and query the database using TOAD and SQL+. However, when I try to connect to the database using the Microsoft .Net Oracle data objects I get the ERROR [IM004]. I am using the same tnsname.ora file and connection string as a colleague who can successfully connect.

ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.

Any suggestions as to why this may be and how I can resolve it?

Thanks for taking the time to read this.
  • Attachment: 5308158.jpg
    (Size: 16.67KB, Downloaded 486 times)
Previous Topic: Help with Discoverer Viewer
Next Topic: How to renew the Wallet SSL?
Goto Forum:

Current Time: Mon Nov 28 04:42:21 CST 2022