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.
  • 2524

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.