Accessing the database on a remote server

bostjank

11-05-2003, 05:13 PM

Hi!

I need to insert records into an Access database that is on a remote server (accessible via internet). How can I connect to it?

Thanks,
Bostjan

A1ien51

11-05-2003, 05:40 PM

you need to know the connection parameters for the server

server name/location, database name and password...

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=ASP+connect+to+Access+Database

bostjank

11-05-2003, 05:50 PM

Yes, but I have troubles with connection string.

This is what I use on a local server, but I cannot modify it for connection on a remote server
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")

If i specify Server.MapPath("http://www.myweb.com/database.mdb") I get

Server.MapPath() error 'ASP 0173 : 80004005'

Invalid Path Character

/schoolgrad/admin/admin_first_www.asp, line 14

An invalid character was specified in the Path parameter for the MapPath method.