°Ô½ÃÆǽ¸¦ ÀÌ¿ëÇؼ °Ô½ÃÆÇÀ» ¸¸µé¾î Àß ¾²°í ÀÖ¾ú½À´Ï´Ù. ±×·±µ¥ °©Àڱ⠾Ʒ¡¿Í °°Àº ¿¡¶ó°¡³³´Ï´Ù.
È£½ºÆÃȸ»ç°¡ ¹Ù²î¾ú°Åµç¿ä.
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") %>
ÀÌ°Ô ÀüºÎ°Åµç¿ä.
¹¹°¡ ¹®Á¦Àϱî¿ä? µµ¿ÍÁÖ¼¼¿ä.
|