Forum Discussion

robarivas's avatar
robarivas
Post Patron
9 years ago

DB2 error: SQL0204N...is an undefined name

I'm trying to connect to an IBM DB2 database on z/OS using the IBM driver (the Microsoft driver requires a package collection to be specified whose value I am unaware of). If I select "Navigate using...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi robarivas,

I have no test enviorment for IBM on z/OS.

What is the error message do you get when choosing "Microsoft Driver" to connect to your database?

Thanks,
Lydia Zhang

robarivas's avatar
robarivas
Post Patron
9 years ago

Hello Anonymous. Below is the error message I receive using the Microsoft driver:

 

Details: "Microsoft Db2 Client: The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805"

  • Potsie's avatar
    Potsie
    New Member
    8 years ago

    Did you find a solution to this problem? I too am trying to connect to zOS DB2.

    • robarivas's avatar
      robarivas
      Post Patron
      8 years ago
      Hi Potsie
      My DBA team did something that made it so that I can connect using the Microsoft (not IBM) option. Unfortunately I don't know what they did differently to get the Microsoft option to work. It's also strange to me that the IBM option still doesn't work. Also, I've found that just connecting with ODBC seems to perform the same as far as I can tell.