dbTalk Databases Forums  

Re: DB2 Connect tools complain about a missing package

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Re: DB2 Connect tools complain about a missing package in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PM \(pm3iinc-nospam\)
 
Posts: n/a

Default Re: DB2 Connect tools complain about a missing package - 08-15-2003 , 10:52 AM






Specific thread
http://groups.google.ca/groups?hl=en...%26scoring%3Dd

Threads about 805n. Dig for syssh* related threads.
http://groups.google.ca/groups?q=SQL...-db2&scoring=d

PM


"Rob Worley" <rob.worley (AT) btopenworld (DOT) com> a écrit dans le message de
news:6ba3e858.0308150020.430a1207 (AT) posting (DOT) google.com...
Quote:
Hopefully this is the right place to post this message...

I'm involved in a technical evaluation of the new .NET managed data
provider. Having downloaded the personal edition of DB2 Connect and
successfully created and tested a connection to our development AS/400
using
the Configuration Assistant, I found that I was unable to establish a
connection using the Visual Studio add-in. The add-in didn't provide any
specific error message.

I then tried using Control Center to list the tables on the AS/400 and
while
it is able to connect to the machine and enumerate instances and
databases,
it always generates the following error message when trying to list the
tables in the database I'm interested in.

[IBM][CLI Driver][AS] SQL0805N Package "SYSSH200 " was
not
found. SQLSTATE=51002

I then tried to run a SQL SELECT query against one of the tables I know
exists in the database by using the managed data provider
programmatically.
This generated an exception with the above message.

The fact that the standard DB2 Connect tools fail to work lead me to
believe
that the problem isn't specific to the .NET managed provider. I've passed
on
the information to our AS/400 guys but they've been unable to help me so
far. Can anyone here provide any suggestions that I can pass on to them?

The AS/400 is running OS/400 version 4 release 5 modification 0 and I'm
running DB2 Connect version 8 fix pack 3. Could this be caused by a
version
mismatch? As you probably guessed by now, I'm no AS/400 expert!

Thanks in advance for any help you're able to offer,

Rob Worley



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.