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.

Does your system return an SQL error ?

If yes please post it

Yes it does, here it is.

SQL Execution Error.

ERROR [51002][NEON][SCOD32.DLL][DB2]dsnt408I SQLCODE = -805, ERROR;
DBRM OR PACKAGE NAME DP954128..OPRXSQ.0D9E7E2D08F1F0F1 NOT FOUND IN PLAN SDBC1010. REASON 02

Here is my SQL statement:

SELECT BATCH, BATCHSTATUS, CLIENT, ACTCOUNT, CURRENTWKST
FROM DP954128.TESTDB01.VWFMBTCH
WHERE (CURRENTWKST = 'A66')

Here is my neon client advanced info:

Subsystem: DSNP
Plan Name: SDBC1010
Catalog Prefix: SYSIBM
Default DB: TESTDB01
Table Filter: TESTDB01

One note is that this same configuration pulls all the data I need into Excel.

Thanks in advance.

Any thoughts?

Not really sadly, have you tried recompiling your function ?