.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.EntryPointNotFoundException' 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!
djmarikAsked:
Who is Participating?
 
bondtraderCommented:
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?
0
 
djmarikAuthor Commented:
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.

0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
bondtraderCommented:
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...
0
 
djmarikAuthor Commented:
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.DllNotFoundException' occurred in ibm.data.db2.dll  Additional information: Unable to load DLL (db2app.dll)."

Any ideas??

--Thanks!
0
 
bondtraderCommented:
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.  
0
 
djmarikAuthor Commented:
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)?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.