CUBRID OLEDB Driver Installation Instructions

The scope of this tutorial is to provide an introduction to the CUBRID OLEDB Data Provider. We will show you where to get the CUBRID OLEDB Provider library, how to setup a CUBRID connection and how to develop some simple applications, mainly using OLE DB Consumer templates.

Download

Download a new installation package file which name is "CUBRID_OLEDB_Provider-<version>-win32-x64.zip".

It will install both CUBRIDProvider32.dll and CUBRIDPRovider64.dll at once. You can find a CUBRID OLEDB Provider installer at:

http://ftp.cubrid.org/CUBRID_Drivers/OLEDB_Driver/ or

http://www.cubrid.org/?mid=downloads&item=oledb_driver

Driver Installation

Run a CUBRID OLEDB Provider Installer (exe) and click the Next / Install Button.

In your installation directory, you can see the following DLL files and uninstall. exe.

DB Connection

Data Link Properties Dialog Box

To access this dialog box in Visual Studio .NET, select Connect to Database from the Tools menu or click the Connect to Database icon in Server Explorer.
You also can open this dialog box by double-clicking a universal data link (.udl) file in Windows Explorer, and in a variety of other ways, including programmatically.

1）you must install Visual Studio first, click “Connect to Database”

2) Choose <other>,and .Net Famework Data Provider for OLE DB, Then click continue button

3) Choose CUBRID OLE DB Provider, then click Data links button

4) Fill in the information, and click Test Connection button, if driver connect database successful, success dialog will pop up.
More information can found in msdn: http://msdn.microsoft.com/en-us/library/79t8s5dk(v=vs.71).aspx

5) A simple method of open dialog
First, create a text file, and modify extension to *.udl: 1.txt -> 1.udl

Second, double click 1.udl, dialog will pop up.

 6)  Setting method of character set

Connection String:

"Provider=CUBRIDProvider;Data Source=demodb;Location=10.34.64.104;User ID=dba;Password=;Port=30000;Fetch Size=100;Charset=utf-8;"

Configuration

The following tutorials will help you when developing your application thru CUBRID OLEDB Provider. 

• CUBRID OLEDB Overview
• OLEDB Connection String
• Configuring Connection String
• OLEDB Consumer Templates Coding