-
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
-
All you need to add is the location of your database.
conSting = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\yourfolder\yourdatabase.mdb"
-
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?
-
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"