[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

set objRecordset = nothing
set objConn = nothing

At 4/9/01 4:47:00 PM, you wrote:
>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
>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