°Ô½ÃÆǽ¸¦ ÀÌ¿ëÇؼ °Ô½ÃÆÇÀ» ¸¸µé¾î Àß ¾²°í ÀÖ¾ú½À´Ï´Ù. ±×·±µ¥ °©Àڱ⠾Ʒ¡¿Í °°Àº ¿¡¶ó°¡³³´Ï´Ù.
È£½ºÆÃȸ»ç°¡ ¹Ù²î¾ú°Åµç¿ä.
Microsoft JET Database Engine error '80004005'
Selected collating sequence not supported by the operating system.
/news/list.asp, line 36
list.asp, line 36 ¿¡´Â
RS.Open SQL, ConnString
ÀÌ·±³»¿ë¹Û¿¡ ¾ø½À´Ï´Ù.
list.aspÀÇ ³»¿ëÀº ¾Æ·¡¿Í °°½À´Ï´Ù. °ø°³ ½î½º°Åµç¿ä.
<%
IPage = Request.QueryString("Page")
If (IPage = "") Then
IPage = "1"
End If
IPage = CInt(IPage)
Field = Request.Form("Field")
Str = Request.Form("Str")
Set RS = SERVER.CreateObject("ADODB.Recordset")
RS.CursorType = 3
SQL = "SELECT Sid,Subject,Visit,Stime FROM NEWS "
if Str<>"" then
SQL = SQL & " WHERE " & Field
SQL = SQL & " LIKE '%" & Str & "%'"
end if
SQL = SQL & " ORDER BY sid DESC"
RS.Open SQL, ConnString
IF (RS.BOF and RS.EOF) Then
TotRecord = 0
TotPage = 0
Else
TotRecord = RS.RecordCount
Rs.pagesize=18
TotPage = RS.PageCount
End if
%>
Á¦°¡ ¿ö³« Ãʺ¸¶ó¼ ±×·±µ¥¿ä. ¾î¶²ÀÌÀ¯¿¡¼ »ý±ä ¿¡¶õ°¡¿ä? È£½ºÆà ȸ»ç¿¡ ¹°¾îº¸¾Ò´õ´Ï ÇöÀç µðºñ ¿¬°á ÄÚ
µå¸¦
spath=server.mappath("/") & "/database/dbname.mdb"
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & spath
¿¡¼
Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &Server.MapPath("/database/dbname.mdb")
ÀÌ·¸°Ô ¹Ù²Ù¶ó´Âµ¥¿ä ¹Ù²Ù¾ú´õ´Ï ¾Æ·¡¿Í °°Àº ¿¡¶ó°¡ ³³´Ï´Ù.
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/news/inc.asp, line 6
Database connection info and driver
--------------------^
inc.asp, line 6¿¡´Â
Database connection info and driver
ÀÌ ³»¿ëÀÌ ÀüºÎ¿¹¿ä.
inc.aspÀÇ ³»¿ëÀº
<%
Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/data/news.mdb")
%>
ÀÌ°Ô ÀüºÎ°Åµç¿ä.
¹¹°¡ ¹®Á¦Àϱî¿ä? µµ¿ÍÁÖ¼¼¿ä.