Connect via OLEDB IBM iSerie

[jlmunoz]

Gentlemen.

Please indicate could help me as I connect via OLEDB to a database DB2/400 on an IBM iSerie from an app.

thanks

[Jeff Luther]

Take a look at TD's documentation. TD ships with the ebook ccod.pdf, which is the manual for connecting to non-SQLBase databases. In there is a section on ODBC, and inside that I see is a section titled "Connecting to DB2/400."

[jlmunoz]

For ODBC I connect seamlessly to the DB2/400 database, what I need is an example of how the connection is made via OLEDB.
thanks

[Jeff Luther]

Perhaps someone else here knows the "Provider=" value + details for DB2/400, but I just searched online for: OLEDB DB2/400

and see a number of links that might help you, including this one: http://msdn.microsoft.com/en-us/library ... 10%29.aspx

As an example, here is a SqlUDL string for connecting to MS SQL Server:

Set SqlUDL = "Provider=SQLOLEDB.1;Password=<password>;Persist Security Info=True;User ID=<user>;Initial Catalog=<catalog>;Data Source=<data source>"


I also just searched for OLEDB here in the forum and got many pages of forum threads on this topic.