...

View Full Version : 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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum