| connect to oracle 9i database in asp.net [message #182147] |
Thu, 13 July 2006 04:58 |
syvinhcd
Messages: 1
Registered: July 2006
|
Junior Member |
|
|
Hi,
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.
syvinhcd
-
Attachment: 5308158.jpg
(Size: 16.67KB, Downloaded 1166 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
