Connecting to acces base on server

[Immz]

hi

I have just started learning asp and i have made one small program that puts different stuff in an acces base. It worked fine, when i tried it on my comp using that virtual web server, but then when i upload it, i dont know how to write my connection string.

set Conn = server.createobject("ADODB.Connection")
conString = "Driver={Microsoft Access Driver (*.mdb)} <- dont know what else to write here

Conn.Open conString

[ajc]

All you need to add is the location of your database.

conSting = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\yourfolder\yourdatabase.mdb"

[Immz]

the problem is how to write that, if i have it on one server and i dont know the whole dir structure. Should i use smt with the dns of the server or what?

[ajc]

Can you not make a ODBC Data Source and then reference that DSN, so when you open the datatbase it would look like

db.Open "YourDSN"