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"
Note If INSERT/UPDATE for a longer string defined in a column is executed, the string will be truncated.