View Full Version : ASP and Database (Microsoft)

07-18-2006, 05:03 PM
Is there anyway that i can get data from a database.

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

07-31-2006, 03:41 PM
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: