ASP connection MySQL Database tutorial example

ASP connection MySQL Database

The first thing to do is install MySQL ODBC 3.51 on the server, as well as the database username and password, as shown in the following code.

The following is the source code: <% strconnection= "Driver={mysql ODBC 3.51 driver};d atabase=weste_net;server=localhost;uid=root;password=" Set conn = Server.CreateObject ("Adodb.connection") Conn.Open strconnection strquery = "SELECT * FROM News" Set rs = Conn.execute (strquery) If not Rs.bof then %> <table> <tr> <td<b> Serial Number </b></td> <td><b> title </b></td> </tr> <% Do as not rs.eof %> <tr> &LT;TD&GT;&LT;%=RS ("id")%></td> <td><%=rs ("Ntitle")%></td> </tr> <% Rs.movenext Loop %> </table> <% Else Response.Write ("No temporary No.") End If Rs.close Conn.close Set conn = Nothing Set rsdata = Nothing %>