PDA

View Full Version : ASP and Database (Microsoft)



queerfm
07-18-2006, 06: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.

scamden1
07-31-2006, 04: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:
http://www.w3schools.com/asp/asp_intro.asp/
Cheers