467,209 Members | 1,319 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

DB2 - OleDb - Unable to use Catalog Library List

I am attempting to use the "Catalog Library List" feature of the
IBMDA400 oledb provider. My connection string is as follows:
new OleDbConnection("Provider=IBMDA400.DataSource.1;Da ta
Source=MyDS;User ID=uid;Password=pwd;Initial Catalog=MyCat;Catalog
Library List=Lib1,Lib2");

When I fully qualify tables I am successful. For Example:

query #1: select * from lib1.table ----> successful

This, of course, defeats the how I would like to use the Catalog
Library List. If I specify:

query #2: select * from table ---> unsuccessful

and returns the error: SQL0204: TABLE in UID type *FILE not found.

I understand that because I didn't declare a Default Collection it
defaulted to my userid (UID). Specifying this, however, has the same
implication as query #1 (not using the catalog library list).

Has anyone successfully used a catalog library list?

May 10 '06 #1
  • viewed: 2865

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by N S S | last post: by
4 posts views Thread by Zalak Dedhia via DotNetMonster.com | last post: by
reply views Thread by Nachi | last post: by
reply views Thread by TechWitch | last post: by
9 posts views Thread by =?Utf-8?B?VE9NX1Bhc2FkZW5h?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.