To search

VFP9 连接mysql代码示例

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/

They posted on the same topic

Trackback URL : http://www.92os.com/trackback/39

This post's comments feed

Page top