Question

vb如何连接操作MYSQL数据库

能给我发一份VB连接MYSQL的源文件吗、还有在请教下VB要连接操作MYSQL数据库是不必须得安装MySQL Connector/ODBC 啊、还有您能给我一份VB连接操作MYSQL的详细资料吗 我的QQ:904539345 如果你能帮我解决这个问题、我把我现在的分全给你了呵呵

Answer 1

必须安装MYSQL的驱动才行，不管是VB还是c++都需要这个驱动。代码如下： Public Function exemysql(ByVal sql As String) As ADODB.Recordset sql = Trim$(sql) Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.Open "Driver=MySQL ODBC 3.51 Driver;" & _ "Server=服务器地址;" & _ "Port=3306;" & _ "Database=数据库名;" & _ "Uid=用户名;" & _ "Pwd=密码" conn.DefaultDatabase = "数据库名" conn.CursorLocation = adUseClient Set rs.ActiveConnection = conn rs.LockType = adLockBatchOptimistic rs.CursorType = adOpenKeyset rs.Open sql Set exesql = rs Set rs = Nothing Set conn = Nothing End Function