asp utf 8 Í·ÎļþÊý¾Ý¿âÁª½Ó³Ø
<%@Language="VBScript" CodePage="65001"%>
<% option explicit%>
<% on error resume next %>
<% Session.CodePage="65001" %>
<% response.charset="utf-8" %>
<%
dim conn,connstr,sql,rs,rs2,rs3
connstr="dbq=" & server.MapPath("../data091003/data091003.mdb") & ";driver=
{microsoft access driver (*.mdb)};"
set conn=server.CreateObject("adodb.connection")
conn.Open connstr
set rs=server.CreateObject("adodb.recordset")
set rs2=server.CreateObject("adodb.recordset")
set rs3=server.CreateObject("adodb.recordset")
%>
Ïà¹ØÎĵµ£º
¿ª·¢»·¾³:VS2008
WEB·þÎñÆ÷:IIS7.0
ΪºÎÔÚµ÷ÊÔʱ,¿ÉÕý³£ÏÔʾ±¨±íÄÚÈÝ,¿ÉÉú³Éºó,ÔËÐÐʱ,Ö»ÏÔʾ±¨±í¿ò¼Ü,²¢²»ÄÜÕý³£ÏÔʾ±¨±íÄÚÈÝ.
ÎÒ°Ñä¯ÀÀÆ÷ËùÓÐÏÞÖÆÑ¡ÏȡÏûÁË,»¹ÊÇÒ»ÑùµÄÎÊÌâ,²»ÖªÎªºÎ.ÕýÔÚѰÕÒ´ð°¸................... ......
Èí¼þÃû³Æ£º·ç¶É¿Æ¼¼ASPÍøÉϹºÎïϵͳ v0912-26
Èí¼þ´óС£º7069k
ÔËÐл·¾³£ºASP/Access
Èí¼þÀà±ð£ºµç×ÓÉÌÎñ
Èí¼þÊÚȨ£ºÃâ·Ñ
¿ª·¢É̼Ò: ·ç¶É¿Æ¼¼
¹Ù·½ÍøÕ¾£ºhttp://www.chinammc.com
ÑÝʾµØÖ·£ºhttp://demo01.chinammc.com
ÏÂÔØµØÖ·: http://w ......
Access Á¬½Ó×Ö·û´®
strConnect = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDatabase.mdb;”
Access 2007 Á¬½Ó×Ö·û´®
strConnect = “Provider=Microsoft.ACE.OLEDB.12.0;Mode=Share Exclusive;Data Source=C:\MyDatabase.accdb;”
MSSQL Server Á¬½Ó×Ö·û´®
strConnect = &ldquo ......
¡¡ASPÁ¬½ÓÊý¾Ý¿âµÄ11ÖÖ·½·¨——±¾ÎÄ×ܽáÁËʹÓÃASPÁ´½Ó¸÷ÖÖÊý¾Ý¿âµÄ·½·¨£º
¡¡¡¡1.AccessÊý¾Ý¿âµÄDSN-lessÁ¬½Ó·½·¨:
set adocon=Server.Createobject("adodb.connection")
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _
Server.MapPath("Êý¾Ý¿âËùÔÚ·¾¶")
¡¡¡¡2.Access OLE DBÁ¬½Ó·½·¨£ ......
aspÖеÄrs.openÓÚconn.executeµÄÇø±ð
rs.open sql,conn£ºÈç¹ûsqlÊÇdelete,update,insertÔò»á·µ»ØÒ»¸ö¹Ø±ÕµÄ¼Ç¼¼¯£¬ÔÚʹÓùý³ÌÖв»ÒªÀ´¸örs.closeÔÚÎļþ×îºóÔÙдrs.close
Öмä¿ÉÒÔÀ´¶à¸ö¼Ç¼¼¯rs1.open sql1,conn£¬×îºóÒ»¿é¹Ø±Õ¼Ç¼¼¯:rs.close rs1.close
con ......