ODBC连接不上mysql

conn = mysql::connect('localhost', 3306, "root", "123456", "ldc");

conn = mysql::connect("localhost", 3306, "root", "123456", "ldc");

conn = mysql::connect(`localhost`, 3306, "root", "123456", "ldc");

都提示 Usage: connect(host, port, user, password, db). host must be a string

版本:DolphinDB_Win64_V1.30.11

请先 登录 后评论

1 个回答

Boye

请检查以下2点:

1.server与插件的版本是否匹配?ODBC插件用了server安装包携带的(即DolphinDB_Win64_V1.30.11\server\plugins\odbc目录下)吗?

2.ODBC连接字符串写得对不对,详情请参阅https://gitee.com/dolphindb/DolphinDBPlugin/tree/master/odbc#41-odbcconnect ,示例如下:

conn2 = conn1=odbc::connect("Driver={MySQL ODBC 8.0 UNICODE Driver};Server=127.0.0.1;Database=ecimp_ver3;User=newuser;Password=dolphindb123;Option=3;") 


请先 登录 后评论
  • 1 关注
  • 0 收藏,902 浏览
  • 965871630@qq.com 提出于 2021-07-08 14:54

相似问题