不明白,为什么连不上,连接字符那些弄对了的嘛。。大家瞧瞧咯。 Dim strconnt As String
strconnt = ""
Set connt = New ADODB.Connection
Dim sevip, Db, user, pwd As String
sevip = "211.144.92.81"
Db = "a0426131852"
user = "a0426131852"
pwd = "112221"
strconnt = "DRIVER={MySql ODBC 5.0.81 Driver};SERVER=" & sevip & ";Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK" '
connt.ConnectionString = strconnt
connt.Open
ssql = "select * from cdb_members "
connt.Execute ssqlconnt.Close
Set connt = Nothing
strconnt = ""
Set connt = New ADODB.Connection
Dim sevip, Db, user, pwd As String
sevip = "211.144.92.81"
Db = "a0426131852"
user = "a0426131852"
pwd = "112221"
strconnt = "DRIVER={MySql ODBC 5.0.81 Driver};SERVER=" & sevip & ";Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK" '
connt.ConnectionString = strconnt
connt.Open
ssql = "select * from cdb_members "
connt.Execute ssqlconnt.Close
Set connt = Nothing
不是,。,connt.Open
到这里就不行了,肯定是前面那里的错。