oConn.Open "Driver={mySQL};" & _
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb;"To connect to a remote databaseoConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"详细看http://jinesc.6600.org/myweb/disp.asp?idd=91&room=40
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb;"To connect to a remote databaseoConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"详细看http://jinesc.6600.org/myweb/disp.asp?idd=91&room=40
http://sunsite.informatik.rwth-aachen.de/mysql/downloads/os-win32.html
http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/Win32/MyOLEDB3.exe
下载安装完有大量 VB + Mysql 的例程
下了之后你就去管理工具-〉数据源(odbc)中建立相应的用户dsn,然后使用这个dsn就行乐