vb6.0如何连接mysql数据库需要详细步骤谢谢

[wzy455252369]

vb6.0如何连接mysql数据库需要详细步骤谢谢

[咸清]

安装mysql ODBC驱动
运行数据库mysql
设置好连接字符串连接即可

[饮水需思源]

'安装mysql驱动
  With g_strDBConn
  If .State = adStateOpen Then .Close
    
  .ConnectionString = " DRIVER={MySQL ODBC 5.1 Driver};" _
  & " SERVER=" & Trim(txtcServerName.Text) & ";" _
  & " DATABASE=" & Trim(txtcDatabaseName.Text) & ";" _
  & " UID=" & Trim(txtcLoginName.Text) & ";" _
  & " PWD=" & Trim(txtcLoginPassword.Text) & ";" _
  & " stmt=SET NAMES GB2312"

  .CommandTimeout = 0
  .Open
  End With

[贝隆]

[Quote=引用 2 楼 leftie 的回复:]
VB code
'安装mysql驱动
With g_strDBConn
If .State = adStateOpen Then .Close

.ConnectionString = " DRIVER={MySQL ODBC 5.1 Driver};" _
& " SERVER=" & Trim(txtcServerName.Text) &am……
[/Quote]
+1

[lxq19851204]

[Quote=引用 2 楼 leftie 的回复:]

VB code
'安装mysql驱动
With g_strDBConn
If .State = adStateOpen Then .Close

.ConnectionString = " DRIVER={MySQL ODBC 5.1 Driver};" _
& " SERVER=" & Trim(txtcServerName.Text) & "……
[/Quote]
+2