Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

OLEDB Connection String


The first thing we need to know in order to create a CUBRID connection is to how to build the connection string.

Looking into the CUBRID documentation (http://www.cubrid.org/manual/841/en/Configuring%20Connection%20Strings), you will find out that in order touse the CUBRID OLE DB Provider, the connection string must be built using the following "pieces":

Item Exampe/Value Description
Provider CUBRIDProvider Provider name. Do not change this value.
Data Source demodb Database name.
Location 127.0.0.1 (or "localhost") The IP address of the CUBRID Broker Server.
User Id dba Database username.
Password xxxxxx User password.
Port 30000 Broker port number (typically 30000 or 33000, for more info see Connecting to a remote CUBRID Database).

For example, to connect to the demodb database, using the public user, on a local CUBRID installation, the connection string will be:

 Provider=CUBRIDProvider;Location=localhost;Data Source=demodb;User Id=public;Port=33000

Please note that in the next provider releases, you will be able to specify in the connection string additional information such as:

  • Connection encoding
  • Auto-commit mode
comments powered by Disqus
Page info
viewed 1381 times
translations en
Author
posted 2 years ago by
CUBRID
Contributors
updated last year by
View revisions
Share this article