djmarik
asked on
.NET and IBM.Data.DB2 Connection Problem
I am creating an ASP.NET web app (vb) and trying to connect to a DB2 database. When attempting to create a new connection object, I receive the following error.
"An unhandled exception of type 'System.EntryPointNotFound Exception' occurred in ibm.data.db2.dll Additional information: Unable to find an entry point named SQLInitializeADONET in DLL db2app.dll."
The error occurrs on the line: Dim myConn as new DB2Connection
For some reason, it won't let me create a new connection object. I have re-installed the IBM Data Provider and re-referenced the IBM.Data.DB2.dll all with no change.
Any help is much appreciated!
"An unhandled exception of type 'System.EntryPointNotFound
The error occurrs on the line: Dim myConn as new DB2Connection
For some reason, it won't let me create a new connection object. I have re-installed the IBM Data Provider and re-referenced the IBM.Data.DB2.dll all with no change.
Any help is much appreciated!
Can you successfully connect outside of your application using the DB2 configuration assistant's "Test Connection" facility? What exact version (fixpak level) of DB2 are you using?
ASKER
I am able to connect to the database using ODBC and a third-party client. Version 8.1.3 FixPack 3 -- I've been searching for a higher fixpack, but that's the best I can find.
Here's a link to the IBM DB2 Fixpak download area:
http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html
Fixpak 7a is the latest...
http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html
Fixpak 7a is the latest...
ASKER
I just uninstalled my FixPack 3 and Installed FixPack 7a from the link you provided. I chose the 'Application Developer Client'. After running my application, I receive an error in the same place, but it is slightly different. The new error reads: "An unhandled exception of type 'System.DllNotFoundExcepti on' occurred in ibm.data.db2.dll Additional information: Unable to load DLL (db2app.dll)."
Any ideas??
--Thanks!
Any ideas??
--Thanks!
It sounds as if your Web Server session may not be correctly configured for the DB2 environment. Is your Web Server running under the same id that you used to test your DB2 ODBC connections? You need to make sure your Web Server can load all of the required DB2 libararies etc..
Hope this helps.
Hope this helps.
ASKER
I understand what you mean. I don't think this is a problem because my webserver is my local machine. To answer your question, yes, it is the same under the same id as the db2 odbc connection.
Besides referencing the Ibm.data.db2.dll what else should I need. That should contain the entire db2 library, correct (or know where to find the rest)?
Besides referencing the Ibm.data.db2.dll what else should I need. That should contain the entire db2 library, correct (or know where to find the rest)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.