When I connect to DB2 on the AS400 using an ODBC DSN, I am able to specify the library list in the DSN. I'd like to connect using an OLEDB provider instead of ODBC, but I can't figure out how to specify the library list. Is there a way to specify the library when using an OLEDB provider?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
connecting to DB2 AS400 using ADO / OLEDB 1
- Thread starter ddiamond
- Start date
-
1
- #2
IBMDA400 is an OLE DB Provider. Here's how I use it and change the library list in my client VB scripts.
hth
Code:
Dim MySystem As New ADODB.Connection
MySystem.Open "Provider=IBMDA400;Data Source=nnn.nnn.nnn.nnn;USER ID=xxxx; PASSWORD=xxxxxx;"
MySystem.Execute "{{CHGLIBL LIBL(MYLIB1 MYLIB2 ... QGPL)}}", Rcds, adCmdText- Thread starter
- #3
- Status