MYSQL *myData; myData = mysql_init((MYSQL*) 0); mysql_real_connect( myData, "192.168.0.100","root", "", szTargetDSN, MYSQL_PORT, NULL, 0 ) 老是报错:Access denied for user 'root'“192.168.0.111”@ (using password: NO) 谁能给我说说
安装 mdac2.5 sp3 mdac 2.8都不带的 最好去网络上找
ODBC Driver for MySQL (via MyODBC) To connect to a local databaseoConn.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;" For more information, see: Programs Known to Work with MyODBC
myData = mysql_init((MYSQL*) 0);
mysql_real_connect( myData, "192.168.0.100","root", "", szTargetDSN, MYSQL_PORT, NULL, 0 )
老是报错:Access denied for user 'root'“192.168.0.111”@ (using password: NO)
谁能给我说说
mdac 2.8都不带的
最好去网络上找
"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;"
For more information, see: Programs Known to Work with MyODBC