I am trying to connect to a DB2 database with Visual Basic using an ODBC driver (NEON) that is already set up on my PC and currently pulling data from tables into Excel.

When I connect with VB the test connection works and it shows the field names but when I create a table adapter or query and execute it I get a "DBRM OR PACKAGE NAME NOT FOUND IN PLAN" error message.

I use MSQuery to design the SQL that pulls data from the DB2 into Excel and I haven't had a problem so I am somewhat perplexed as to why another Microsoft product is unable to use the same connection.

Any help is appreciated.