标签归档：ado

TOP ADO programming TIPS –

发表于由
回复

Connecting to data stores

How do I connect to a MS Access 2000 database?
ADOConnection.ConnectionString := ‘Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:MyDatabase.mdb;Persist Security Info=False’;

How do I connect to a password protected MS Access 2000 database?
ADOConnection.ConnectionString := ‘Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=XXXXXX;DataSource=C:MyDatabase.mdb;Persist Security Info=False’;

What provider should I use for MS Access
For MS Access 97 use Microsoft.Jet.OLEDB.3.51
For MS Access 2000 use Microsoft.Jet.OLEDB.4.0

How do I connect to a dBase database?
ADOConnection.ConnectionString := ‘Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:MyDatabase.mdb;Extended Properties="dBase 5.0;"’;

How do I connect to a Paradox database?
ADOConnection.ConnectionString := ‘Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:MyDatabase.mdb;Extended Properties="Paradox 7.X;"’;

How do I connect to a MS Access database on a CD (read only) drive?
ADOConnection.Mode := cmShareExclusive;

继续阅读 →

用ADO连接MYSQL的连接字符串

发表于由
回复

How to set up the dbGo (ADO) ConnectionString for mySQL database

From Zarko Gajic,

If your database choice is mySQL and you are using dbGO (ADO) components, over mySQL ODBC 3.51 driver or MySQL Connector/ODBC 5.0, this is how your TADOConnection’s ConnectionString property should look:

  • When using “ODBC 3.51 LOCAL database“:

    ‘DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword;OPTION=3;’

  • When using “ODBC 3.51 REMOTE database“:

    ‘DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3;’

  • When using “ODBC 5.0 LOCAL database“:

    ‘DRIVER={MySQL Connector/ODBC v5}; SERVER=localhost; DATABASE=myDatabase; UID=myUsername; PASSWORD=myPassword;OPTION=3;’

  • When using “ODBC 5.0 REMOTE database“:

    ‘DRIVER={MySQL Connector/ODBC v5}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; UID=myUsername; PASSWORD=myPassword;OPTION=3;’

Note: “data.domain.com” is the name of the data server, “myDatabase” is the name of the database, “myUsername” is the name of the user, “myPassword” is the password for “myUsername”

delphi中使用ado连接mysql乱码解决

发表于由
回复

delphi中，使用ado连接mysql，adoconnection的providor 设为：MSDASQL.1，可以先用系统数据源连接，然后在程序里面用连接字符串。

 

查询后，发现，listbox里面显示中文乱码

image

参考http://bbs.mysql.cn/viewthread.php?tid=364&extra=page%3D1%26amp%3Bfilter%3Ddigest

发现，可以执行以下语句

SET NAMES ‘CHARSETNAME’

用来设置客户端的字符集，例如：”SET NAMES ‘GB2312′”，可设置客户端的字符集为gb2312 。（UCS2暂时不可用）

在连接上数据库后，上面的语句以sql语句执行，即可。

执行后，乱码解决

image