How to realize DB2 Development of OLE DB in C #

This article shows you how to realize the DB2 development of OLE DB with C #. The content is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Visual Studio.NET is still quite common, here we mainly introduce the DB2 development of C # to implement OLE DB, including the introduction of ole DB for DB2 driver and so on.

Implementing DB2 Development of OLE DB with C #

In visual Studio.NET Beta version 1, the ODBC method of ADO.NET is usually used to access non-SQL Server databases such as IBM DB2, while in Beta 2, OLE DB is used to access the database.

The connection string in Beta1 mainly needs to declare the DNS name of the ODBC of the database, but the string of OLE DB connection in Beta 2 is more complex and uses different classes. As databases such as DB2 are widely used in mainframes and other applications, .NET will naturally fully support this kind of programming development. For this reason, the following article will gradually elaborate on the DB2 development of OLE DB in C #.

Ole DB for DB2 driver

First of all, the OLE DB driver of DB2 is not directly provided in Visual Studio.NET and Windows 2000 Server, so you need to download the Microsoft Host Integration Server 2000 software package, which contains OLE DB Provider and ODBC driver for DB2, you need to download the Server software package, and choose to install Data Integration during installation. After the installation is complete, you can use the DB2 driver of its OLE DB.

Set up a database connection

First, we need to configure the client settings of DB2, open the server explorer in the view menu, add a connection to its data connection, select Microsoft OLE DB Provider for DB2 when you specify the program options, and enter the following information in the next connection options:

◆ Data Source: QCDB (please modify as appropriate)

◆ Network:TCP/IP

◆ IP Address: database server address

◆ Network Port:DB2 service port

◆ Username: the user name of the database access permission

◆ Password: the user password

◆ Database initial Catalog:QCDB

◆ Package collection:QCDB

◆ default schema:Userid

The above content is how C # implements the DB2 development of OLE DB. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.