Biarkan ASP cocok dengan mysql
Alat diperlukan
mysql-4.1.11-win32
MyoDBC-3.51.11-1-Dll
myodbc-3.51.11-1-win
mysqlcc-0.9.4-win32
-------------------------------------------------------------------
Daftar file mydbc.reg
Regedit4
[Hkey_local_machine/software/odbc/odbcinst.ini/myodbcdriver]
"USAGECOUNT" = DWORD: 00000002
"Driver" = "c: //windows//system//myodbc.dll"
"Setup" = "c: //windows//system//myodbc.dll"
"Sqllevel" = "1"
"FileUsage" = "0"
"Driverodbcver" = "03.51"
"ConnectFunctions" = "yyy"
"Apilevel" = "1"
"Cptimeout" = "120"
[Hkey_local_machine/software/odbc/odbcinst.ini/odbcdrivers]
"myodbcdriver" = "terpasang"
-------------------------------------------------------------------
Buat database tautan file ASP
Contohnya adalah sebagai berikut
WindowsDSnName: Nama DSN yang ingin Anda buat
Mysqlhost (nameorip): nama atau alamat IP server mysql, biasanya mengisi localhost
Mysqldatabasename: admin
Database: Admin
Kata sandi: 000000
Port (IFNOT3306):
SqlCommandonconnect:
Dua kode ASP berikut untuk menghubungkan database
1. Gunakan DSN
<%
strconnection = "dsn = admin; driver = {myodbddriver}; server = localhost; uid = root; pwd = 000000; database = admin"
Setadodataconn = server.createObject ("adodb.connection")
adodataconn.openstrconnection
strquery = "pilih*fromser"
SetRs = adodataconn.execute (strquery)
Ifnotrs.boftthen
%>
<able>
<tr>
<td <b> Nama pengguna </b> </td>
<td> <b> kata sandi </b> </td>
</tr>
<%
Dowhilenotrs.eof
%>
<tr>
<td> <%= rs ("nama pengguna")%> </td>
<td> <%= rs ("kata sandi")%> </td>
</tr>
<%
rs.movenext
Lingkaran
%>