작성 포맷 :
TEXT 모드, 자동 줄바꿈 사용
Microsoft Access Database Engine 2010 재배포 가능 패키지 설치
다운로드 경로 : https://www.microsoft.com/ko-kr/download/details.aspx?id=13255
샘플 코드 :
<%@ language="VBSCRIPT"%>
<%
Session.CodePage = 949
Response.CharSet = "euc-kr"
Set Conn = Server.CreateObject("ADODB.Connection")
DBtest="Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & Server.MapPath("Test01.accdb") & ";Persist
Security Info=False"
Response.Write DBtest & "<br/>"
Conn.Open DBtest
set record = server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM testTable"
record.Open strSQL, Conn, 1
for i = 1 to record.RecordCount
Response.Write "key : " & record("key")
Response.Write " int : " & record("type_int")
Response.Write " string : " & record("type_string")
Response.Write " bool : " & record("type_bool")
Response.Write " date : " & record("type_date")
Response.Write "<br/>"
record.MoveNext
Next
record.Close
set record = nothing
Conn.Close
set Conn = nothing
%>
정상 동작 확인했습니다. ... [Mr.NET!] |