Introduction to CUBRID Manual 
API Reference 
Using Data Link Property Dialog Box 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.