remote Access 2000 connection string

  • Thread starter Thread starter Konrad
  • Start date Start date
K

Konrad

Hi

How looks remote Access 2000 connection
string. Database is placed on another computer,
WWW serwer and i would like to connect
to it from client machine.

Thanks
Konrad
 
Hi Konrad,

Since you cannot use IP address in a connection string to specify remote
Access database, best way to handle this is to use Web Service. This is
probably simplest and most scalable way to work with the remote Access
database
 
I've tried MS Remote provider but it doesn't work.
The exception is during Fill command
that I'am using invalid cast.

Connecton string looks like:

Provider=MS Remote;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Avista.mdb;Remote Server=http://localhost



Thanks

Konrad
 
Yes I see that it is.

Thanks
Konrad

Val Mazur said:
Hi Konrad,

Since you cannot use IP address in a connection string to specify remote
Access database, best way to handle this is to use Web Service. This is
probably simplest and most scalable way to work with the remote Access
database
Click to expand...
 
Back
Top