ASP and Database (Microsoft)

[queerfm]

Is there anyway that i can get data from a database.

i just need to know how as i don't know how thanks.

[scamden1]

Hi, you can use this connection string to connect to a database.

Dim strConn
'Open Connection to the database
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("otcstatus.mdb") & ";"

objRS.Open strSql, strConn

This wont actually do anything besides open the database connection. If you would like to print database information to the screen you will need a little more code.
Hope this helps but if not, take a look at this site:
http://www.w3schools.com/asp/asp_intro.asp/
Cheers