asp邊接access
<%
datapath = "message.mdb"
set conn = server.createobject("ADODB.Connection")
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source="& server.MapPath(datapath)
conn.open constr
%>
ado邊接sql(vb)
dim cnn as new adodb.connection
1. CNN.Open "provider=sqloledb;server=服務器名;database=數據庫名;uid=用戶名;pwd=密碼"
2.利用建立udl文件邊接數據庫
建立一個.udl的文件,然后cnn.open "file name=d:/文件名.udl"即可