(1)利用odbc访问mysql set conn=Server.CreateObject("ADODB.Connection") conn.Open("DSN=PHP_MYSQL;uid=root;PWD=YOUPASSWORD") (2)不设DSN,直接访问mysql. set conn=Server.CreateObject("ADODB.Connection") conn.Open("driver={MySQL};server=localhost;uid=root;pwd=youpassword;database=youdatabase")
set conn=Server.CreateObject("ADODB.Connection")
conn.Open("DSN=PHP_MYSQL;uid=root;PWD=YOUPASSWORD")
(2)不设DSN,直接访问mysql.
set conn=Server.CreateObject("ADODB.Connection")
conn.Open("driver={MySQL};server=localhost;uid=root;pwd=youpassword;database=youdatabase")
因为它的ODBC驱动可设置项比较多
你也可以通过上面的做法呀
set conn = Server.CreateObject("ADODB.Connection")
on error resume next
conn.Open "driver={MySQL ODBC 3.51 Driver};DATABASE=test;SERVER=localhost;UID=root;PASSWORD=;PORT=3306;OPTION=3;"
response.write err.Description
%>
请大侠帮忙!
set conn = Server.CreateObject("ADODB.Connection")
on error resume next
conn.Open "driver={MySQL ODBC 3.51 Driver};DATABASE=mysql;SERVER=localhost;UID=root;PASSWORD=密码;"
response.write err.Description
%>空密码怎么输入啊?我不知道 但是这个可以连上mysql这个库。我从apache连接,不知道你们怎么样=_= asp不会 呵呵