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.
Notice: If your CUBRID OLEDB driver version is 9.1.0.p1 or later, only one installation package is needed for both Windows 32 bit and 64 bit. Our new OLEDB installer supports CUBRID DB engine 8.4.1 or later.
If your CUBRID OLEDB Driver version is 9.1.0 or older, it may have a problem on 64 bit operating system. Please see our installation tutorial for an old version: http://www.cubrid.org/wiki_apis/entry/cubrid-oledb-driver-installation-instructions-old
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:
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.
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
"Provider=CUBRID OLE DB Provider;Data Source=demodb;Location=10.34.64.104;User ID=dba;Password='';Port=30000;Fetch Size=100;Charset=utf-8;"
7) Setting method of isolevels
"Provider=CUBRID OLE DB Provider;Data Source=demodb;Location=10.34.64.104;User ID=dba;Password='';Port=30000;Fetch Size=100;Charset=utf-8;Autocommit Isolation Levels=256;"
1) The feature is supported by the version 9.1.0.p2 and later.
2) If you don't specify isolation level in the connection string, it will be set as the default value - 4096.
3) This "Autocommit Isolation Levels" only acts on the isolation level of OLEDB Connection, but not for the transaction. If you want to change the isolation level of transaction, you need to specify the isolation level in the function OleDbConnection.BeginTransaction().
The following tutorials will help you when developing your application thru CUBRID OLEDB Provider.