General discussion forum about all databases other than SqlBase.
Please indicate could help me as I connect via OLEDB to a database DB2/400 on an IBM iSerie from an app.
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."
For ODBC I connect seamlessly to the DB2/400 database, what I need is an example of how the connection is made via OLEDB.
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.
Who is online
Users browsing this forum: [Ccbot] and 0 guests