ODBC可以连接上 Mysql 5.1.37 阿里云的数据库!
但是使用VB调用的时候无法连接成功
我操作系统是windows 64位,下载的ODBC是32位的!
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
用的是VB6.0 从网络上抄的代码如下:
Dim strCn As String
Dim db_host As String
Dim db_user As String
Dim db_pass As String
Dim db_data As String
Dim sql As String
db_host = "bdm286382480.my3w.com"
db_user = "bdm286382480"
db_pass = "057464418825"
db_data = "bdm286382480_db"
strCn = "DRIVER={MySQL ODBC 5.1 Driver};" & _
"SERVER=" & db_host & ";" & _
"DATABASE=" & db_data & ";" & _
"UID=" & db_user & ";PWD=" & db_pass & ";" & _
"OPTION=3;stmt=SET NAMES GB2312"
cn.Open strCn