B
berandor
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;Data
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?
IBMDA400 oledb provider. My connection string is as follows:
new OleDbConnection("Provider=IBMDA400.DataSource.1;Data
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?