Newbie - Trying to connect to an access table via ASP

keithl posted this at 01:22 — 29th May 2001.

They have: 40 posts

Joined: Apr 1999

Hello,

I am an ASP newbie and I am trying to connect to my access table via ASP.

my table directory (taken from my FTP software listing) is:

/e:/97/amazinglarryonline.com/user/htdocs/tables/amazing_larry.mdb

Now you can set a DSN connection through their control panel (win2000hoster.com is the company)

This is what they said when I requested HOW to make the connection:

************************************************
im afraid that we can support your requist or debug it.. its out of our
work!
but as a general hint the database abolute file will be like
e:\domains\your_domain\user\htdocs\any_folder\the_mdb_file

but if you use the control panel for the mdb file in URL:
http://your_domain/any_folder/any_file.mdb

the part you must write in the control panel will be:

htdocs/any_folder/any_file.mdb

************************************************

Can anybody help me CONNECT to the table. I think that I should put:

htdocs/tables/amazing_larry.mdb for the control panel DSN connection

But then how do I connect to it??

Sorry, I am a VB beginner, and have SOME common sense, but I can't seem to get this going!

Thanks in advance!
Keith
http://www.keithlubrant.com

keithl posted this at 03:03 — 29th May 2001.

They have: 40 posts

Joined: Apr 1999

Got it to work.....

I used:

accessdb="e:\domains\amazinglarryonline.com\filename"
myDSN="DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN=myDSN & "DBQ=" & accessdb

dim conn, rs, SQL
set conn=server.createobject("adodb.connection")
conn.open myDSN