Connecting to an Access Database Using File DSN and ASP/ADO
Posted on 2006-05-18
My question is concerning how to use ASP in conjuction with a hosting service through godaddy.com.
I want to include my scripting in the question but I am not sure where to start or what part to include aside from copying everything and pasting it which could just do more harm than good.
I would really appreciate help with this question because right now it is over my head. I assigned this question 250 points assuming that is means its out of my leauge.
Here are some specific resources concerning my problem:
*godaddy's.com's help center code template which I am supposed to incorporate into my code*
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name
dsn_name = "your_dsn_name"
fieldname = "your_fieldname"
tablename = "your_tablename"
sDSNDir = Server.MapPath("_dsn")
connectstr = "filedsn=" & sDSNDir & "\" & dsn_name
Set oConn = Server.CreateObject("ADODB.Connection")
qry = "SELECT * FROM " & tablename
Set oRS = oConn.Execute(qry)
if not oRS.EOF then
while not oRS.EOF
response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & " "
Set oRs = nothing
Set oConn = nothing