remote database blues

[transparent]

I have two servers. One contains asp pages, the other houses an access database. I need to connect to this database (on server1) from asp pages (on server2). I want to use a dsn-less connection. I have having trouble getting this to work. Can anybody see errors in the following connection string:

Provider=MS Remote; Remote Server=

http://www.test.co.uk;

Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source="E:\MED046\

http://www\docs\database\test.mdb"

Cheers

 

[williamu]

I don't know if Remote Server is a legitimate entry for the Connection string. Assuming it is you want to remove the http:... from it and replace it with the IP address of the Internal NIC of the Server otherwise you will end up going out to the internet and back in again. Which may in fact be your problem.

Also, E: drive is deemed to be local here you will need to change that to the \\Server\Sharename I would guess.

HTH
William
Software Engineer
ICQ No. 56047340