6月 30, 2011

ADO Database Connection Examples(ASP程式寫法)

ADO can be used to access databases from your web pages.
有二種寫法,
方法一:Create a DSN-less Database Connection

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
%>


方法二,Create an ODBC Database Connection


<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "northwind"
%>

沒有留言:

張貼留言