Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    22

    Unanswered: Connecting to DB2 with VB .NET

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow sql

    Does your system return an SQL error ?

    If yes please post it
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Jun 2006
    Posts
    22
    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.
    Last edited by Nebraska_God; 06-22-06 at 10:29.

  4. #4
    Join Date
    Jun 2006
    Posts
    22
    Any thoughts?

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Hmm

    Not really sadly, have you tried recompiling your function ?
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •