MYSQLݿС㡢ٶȿ졢ѵŵΪܶվĿǰѡݿ⣬һ㶼PHP+MYSQLֶ̬ҳ棬
ʵASPҲʹMYSQLݿ⿪̬ҳ棬СҲǸոѧᣬҶдƪ¹ο


ֱӰװ mysql-connector-odbc-3.51.12-win32.msi ȻCONN.ASPmysqlӴ뼴


<% 
strconnection="DefaultDir=;Driver={myodbc driver};server=localhost;uid=root;pwd=;database=nvtdata"
Set adoDataConn = Server.CreateObject("ADODB.Connection") 
adoDataConn.Open strConnection

strQuery = "SELECT * FROM user" 
Set rs = adoDataConn.Execute(strQuery) 
If Not rs.BOF Then 
%> 




ASPļݿ⡣
ַһODBCԴнһϵͳDSNҷֲҲASPʹMYSQL,Ľ
򿪿/ODBDԴѡϵͳDSN,ȻһµDSN,ѡmyodbd driver,һԻmysql    Ϣ
Windows DSN name: ҪDSN
Mysql Host (name or ip):MysqlƻIPַͨlocalhost
Mysql database name:ҪʹݿƣݿMysqlнʹһӡݿhc188
ݱuser ݱֶηֱǣusernamepassword,뼸ݡ
user:ݿûrootû
password:ݿû룬ûУԲ
Port(if not 3306)MysqlڷĶ˿ڣĬΪ3306
SQL command on connect:ʹsqlݿ⣬Բ
дϺѡOK档

ݿASP룡
            
<% 
strConnection = "dsn=hc188;driver={myodbd driver};server=localhost;uid=root;pwd=;database=hc188" 
Set adoDataConn = Server.CreateObject("ADODB.Connection") 
adoDataConn.Open strConnection

strQuery = "SELECT * FROM user" 
Set rs = adoDataConn.Execute(strQuery) 
If Not rs.BOF Then 
%> 
<TABLE> 
<TR>
<TD<b>username</b></TD>
<TD><b>password</b></TD>
</TR> 
<% 
Do While Not rs.EOF 
%> 
<TR>
<TD><%=rs("username")%></TD>
<TD><%=rs("password")%></TD>
</TR> 
<% 
rs.MoveNext 
Loop 
%> 
</TABLE> 
<% 
Else 
Response.Write("Sorry, no data found.") 
End If 

rs.Close 
adoDataConn.Close 
Set adoDataConn = Nothing 
Set rsEmailData = Nothing 
%>

ڶַʹϵͳDSNǷҲʹMYSQLݿأǿԵġ

ܼ򵥣ASPڶдΪ

strconnection="DefaultDir=;Driver={myodbc driver};database=nvtdata"

ֵķַ֣û붼ҪͿʹá

ϴȫͨ
           
ˣȫĽˣǲǺܼأϣܰ㣡