database connection issue please help

[lori]

hello, i am new to ASP, not access neccisarily. i would
like to know how i would go about connecting my db to my
ASP page. My ASP host is http://www.7host.com i took am
access class but its been awhile, so i need some help.
thank you
lori
..

 

[Dan Artuso]

Hi,
Here are the basics for a connection:
Dim cnn As ADODB.Connection

Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=" & App.Path & "\patchpusher.mdb" & ";" & _
"User Id=admin;" & _
"Password="

Substitute the path to your db for the Data Source.
If you are totally new to ASP, pick up a book at your local bookstore.
Or google on ASP tutorial.

There are lots of sites out there.
Try this one:
http://www.4guysfromrolla.com/webtech/042599-1.shtml