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
Page info
viewed 666 times
![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)"){kind=icon}
CUBRID
![[Level:0]](http://www.cubrid.org/modules/point/icons/default/0.gif "Rank: 0/30, reputation score 1 (16% completed for the next level)"){kind=icon}
cd_interface
![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 21 (3% completed for the next level)"){kind=icon}
Esen SagynovShare this article