goConn = CREATEOBJECT("ADODB.Connection")
goConn.ConnectionString ="Provider=MSDASQL.1;Password=*******;Persist Security Info=False;User ID=root;Data Source=myodbc;Initial Catalog=dbf_main"
// 连接串的使用Provider=MSDASQL.1;Password=*******;Persist Security Info=False;User ID=root;Data Source=myodbc;Initial Catalog=dbf_main
goConn.Open
RS = CREATEOBJECT("adodb.recordset")
RS.open('select * from userinfo ',goConn,3,1)
RS.movefirst
DO WHILE !RS.eof()
IF !ISNULL(rs.fields(3).value) OR rs.fields(3).value<>""
?rs.fields(3).value
RS.MOVENEXT
ENDIF
ENDDO
————————————————
ODBC 下载地址
https://download.cs dn.net/download/jack_wang0823/12047451
原地址
https://cdn.mysql.com//Downloads/Connector-ODBC/5.2/mysql-connector-odbc-noinstall-5.2.7-win32.zip
————————————————
版权声明:本文为CSDN博主「jack_wang0823」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csd n.net/jack_wang 0823/article/details/103668805
https://www.connectionstrings.com/mysql-connector-odbc-5-2/