查看: 129|回复: 0

    delphi连接mysql不用添加DSN(mysql connector odbc 5.1版)

    [复制链接]

    249

    主题

    249

    帖子

    596

    积分

    管理员

    Rank: 9Rank: 9Rank: 9

    积分
    596
    发表于 2022-7-7 15:50:20 | 显示全部楼层 |阅读模式
    delphi连接mysql不用添加DSN(mysql connector odbc 5.1版)

    一、下载安装mysql驱动
    http://mysql.com/downloads/connector/odbc/
    二、添加adoconnection,adoquery,使用以下连接字符串
    http://www.connectionstrings.com/mysql#p31
    adoconnection的属性ConnectionString填入以下所需要的连接情况对应字符串,在软件发布时,把mysql-connector-odbc-5.1.8-win32.msi安装程序一起附带着,先安装驱动,即可正常使用。
    Local database
    Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsernameassword=myPassword;Option=3;

    Remote database
    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsernameassword=myPassword;Option=3;

    Specifying TCP/IP port
    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddressort=3306;Database=myDataBase;User=myUsernameassword=myPassword;Option=3;

    Specifying character set
    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;charset=UTF8;Database=myDataBase;User=myUsernameassword=myPassword;Option=3;

    Specifying socket
    This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections.
    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsernameassword=myPassword;Socket=MySQL;Option=3;
    On Windows, the socket variable is the name of the named pipe that is used for local client connections. The default value is MySQL.

    On Unix platforms, the socket variable is the name of the socket file that is used for local client connections. The default is /tmp/mysql.sock.


    Using SSL
    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsernameassword=myPassword;sslca=c:/cacert.pem;sslcert=c:/client-cert.pem;sslkey=c:/client-key.pem;sslverify=1;Option=3;
    SSLCA specifies the path to a file with a list of trust SSL CAs

    SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection.

    SSLKEY specifies the name of the SSL key file to use for establishing a secure connection.




    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    QQ|手机版|小黑屋|源码资源网 ( 鲁ICP备2021043233号-3 )

    GMT+8, 2022-10-1 08:42

    邮箱:312337667@qq.com 客服QQ:312337667(工作时间:7:00~23:00)

    © Powered by Net188.com X3.4

    快速回复 返回顶部 返回列表