Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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.

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

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.

image003.jpg

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

image005.jpg

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”

 image001p.jpg

 

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

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

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

image004p.jpg

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

image005p.jpg

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

 

 6)  Setting method of character set

Connection String:

"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

Connection String:

"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;"

OLEDB Cubrid Value
ISOLATIONLEVEL_READUNCOMMITTED TRAN_COMMIT_CLASS_UNCOMMIT_INSTANCE 256
ISOLATIONLEVEL_READCOMMITTED TRAN_COMMIT_CLASS_COMMIT_INSTANCE 4096
ISOLATIONLEVEL_REPEATABLEREAD TRAN_REP_CLASS_REP_INSTANCE 65536
ISOLATIONLEVEL_SERIALIZABLE TRAN_SERIALIZABLE 1048576

 

Notice:

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(). 

 

Configuration

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

 

comments powered by Disqus
Page info
viewed 2896 times
translations en
Author
posted last year by
cd_interface
Contributors
updated last year by
View revisions
Share this article