How to use IBM DB2 for i .NET Data Provider and Data Provider for OLEDB and ODBC
This article describes about the Data Providers used in IBM DB2 and also describes .NET framework Data Providers used for OLEDB and ODBC.
i .NET Data Provider
Command used for i .NET data provider is
DataSource=server_add;User Id=username;Password=password; DataCompression=True;
|
IBM client Access for OleDb provider
Connection string which is used for wrapping OleDbConnection class that calls the underlying OLEDB provider.
Provider=IBMDA400;Data Source=system_name;User Id=username;Password=password; |
IBM client Access for ODBC driver
The connection string used for wrapping OdbcConnection class that calls the underlying ODBC driver.
Driver={client Access ODBC Driver (32-bit)};System=system_name;uid=username;pwd=password;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here