Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 



Configuring Connection String

When you program the CUBRID OLE DB Provider using ADO (ActiveX Data Object) or ADO.net, write the connection string as follows:

Item

Example

Description

Provider

CUBRIDProvider

Provider name

Data source

demodb

Database name

Location

127.0.0.1

The IP address of the CUBRID Broker Server

User ID

PUBLIC

User ID

Password

xxx

Password

Port

33000

Broker port number

Fetch Size

100

Fetch size

A connection string using the above example is as follows:

"Provider=CUBRIDProvider;Data Source=demodb;Location=127.0.0.1;User ID=PUBLIC;Password=xxx;Port= 33000;Fetch Size=100"

Remark

Because a semi-colon is used as a separator in URL string, it is not allowed to include a semi-colon for password (Password) when specifying it in connection string.

Note If INSERT/UPDATE for a longer string defined in a column is executed, the string will be truncated.