[thelist] ASP & MS Access
John Meyer
john_meyer at geocities.com
Mon Apr 9 19:14:20 CDT 2001
The best way to accomplish this is through a DSN connection.
For this recipe, you will need
* a DSN connection named client
* 1 connection object
* 1 recordset object
<%
dim objConn, objRecordset
set objConn = Server.CreateObject("ADODB.Connection")
set objRecordset = Server.CreateObject("ADODB.Recordset")
objConn.Open "DSN=client;"
objRecordset.Open "SomeTable", cn, adOpenForwardOnly, adLockReadOnly
do until objRecordset.EOF
dim strFld
for each strFld in objRecordset.Fields
Response.Write strFld.Value
next
objRecordset.Movenext
loop
objRecordset.Close
objConn.Close
set objRecordset = nothing
set objConn = nothing
%>
At 4/9/01 4:47:00 PM, you wrote:
>Hi,
>
>I have quite a bit of experience designing php/mysql sites, but none with
>ASP/whatever. A client of ours has an NT server set up with ASP pages and a
>Microsoft Access database. I do not understand how ASP and Access can
>interact with each other - in my php/mysql experience, my php script would
>"connect" to the mysql database application. How is this accomplished using
>ASP/Access?
>
>Cheers,
>
>Beau Hartshorne, Web Developer
>Hot House Marketing & Design Inc
>24 - 532 Herald Street, Victoria BC V8W 1S6
>t 250.361.9140 f 250.361.9154
>
>Visit us online at www.gohothouse.com
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
>
More information about the thelist
mailing list