[MYSQL] asp에서 mysql 연동, 데이터 불러오기

http://dev.mysql.com/downloads/connector/odbc/ <-여기에서 ODBC를 설치후 서버에 연결할 mysql을 셋팅해준후 아래의 소스로 연결이 됐는지를 확인한다.

<%

'// <OBJECT> 태그를 이용한 ODBC 연결

%>

<OBJECT RUNAT="server" PROGID="ADODB.Connection" id="dbconn"></OBJECT>

<OBJECT RUNAT="server" PROGID="ADODB.Recordset" id="rs"></OBJECT>

<%

'//-----------------------------------------------------------------//

'MYSQL ODBC Connection 문자열

'DSN -- ODBC DSN, UID -- 데이타베이스 사용자, PWD -- 데이타베이스 비밀번호

dbconn.Open("DSN=connector;UID=root;PWD=pass;")

'//-----------------------------------------------------------------//

if dbconn.errors.count = 0 then

     response.write "Connected Successfully!<br><br>"

Else

     Response.write "Fail!!<br><br>"

end if

sql = "select * from table limit 0, 200;"

rs.open sql,dbconn

If Not(rs.bof Or rs.eof) Then arrRS = rs.getrows()

rs.close

dbconn.close ' nothing 은 안해줘도 된다. (OBJECT 선언을 하였기 떄문에)

If IsArray(arrRS) Then

     Response.write "<table border=""1"" cellpadding=""3"">"

     For i = 0 To UBound(arrRS,2)

          Response.write "<tr>"

          Response.write "<td>" & arrRS(0,i) & "</td>"

          Response.write "<td>" & arrRS(1,i) & "</td>"

          Response.write "<td>" & arrRS(2,i) & "</td>"

          Response.write "<td>" & arrRS(3,i) & "</td>"

          Response.write "<td>" & arrRS(4,i) & "</td>"

          Response.write "<td>" & arrRS(5,i) & "</td>"

          Response.write "<td>" & arrRS(6,i) & "</td>"

          'Response.write "<td>" & arrRS(7,i) & "</td>"

          'Response.write "<td>" & arrRS(8,i) & "</td>"

          'Response.write "<td>" & arrRS(9,i) & "</td>"

          'Response.write "<td>" & arrRS(10,i) & "</td>"

          'Response.write "<td>" & arrRS(11,i) & "</td>"

          Response.write "<tr>"

     Next

     Response.write "</table>"

Else

     Response.write "데이터가 없습니다.<br>"

End If

Set arrRS = nothing

%>