remote Access 2000 connection string

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

William
Wed Jun 02 14:50:49 CDT 2004

Check out the connection string for the OleDb provider and Access
http://www.connectionstrings.com/

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
"Konrad" <konrad007@poczta.onet.pl> wrote in message
news:c9l7qn$pff$1@nemesis.news.tpi.pl...
> 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
>
>

Val
Wed Jun 02 17:31:50 CDT 2004

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

--
Val Mazur
Microsoft MVP


"Konrad" <konrad007@poczta.onet.pl> wrote in message
news:c9l7qn$pff$1@nemesis.news.tpi.pl...
> 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
>
>

Konrad
Wed Jun 02 23:18:24 CDT 2004

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




"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:e6Q1#oNSEHA.556@TK2MSFTNGP10.phx.gbl...
> Check out the connection string for the OleDb provider and Access
> http://www.connectionstrings.com/
>
> --
>
> W.G. Ryan, eMVP
>
> http://forums.devbuzz.com/
> http://www.knowdotnet.com/williamryan.html
> http://www.msmvps.com/WilliamRyan/
> http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
> "Konrad" <konrad007@poczta.onet.pl> wrote in message
> news:c9l7qn$pff$1@nemesis.news.tpi.pl...
> > 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
> >
> >
>
>

Konrad
Wed Jun 02 23:18:58 CDT 2004

Yes I see that it is.

Thanks
Konrad

"Val Mazur" <group51a@hotmail.com> wrote in message
news:uO9UlFPSEHA.3012@tk2msftngp13.phx.gbl...
> 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
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Konrad" <konrad007@poczta.onet.pl> wrote in message
> news:c9l7qn$pff$1@nemesis.news.tpi.pl...
> > 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
> >
> >
>
>

William
Thu Jun 03 07:48:05 CDT 2004

It's the connection string.

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
"Konrad" <konrad007@poczta.onet.pl> wrote in message
news:c9m8vk$99k$1@nemesis.news.tpi.pl...
> 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
>
>
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:e6Q1#oNSEHA.556@TK2MSFTNGP10.phx.gbl...
> > Check out the connection string for the OleDb provider and Access
> > http://www.connectionstrings.com/
> >
> > --
> >
> > W.G. Ryan, eMVP
> >
> > http://forums.devbuzz.com/
> > http://www.knowdotnet.com/williamryan.html
> > http://www.msmvps.com/WilliamRyan/
> > http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
> > "Konrad" <konrad007@poczta.onet.pl> wrote in message
> > news:c9l7qn$pff$1@nemesis.news.tpi.pl...
> > > 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
> > >
> > >
> >
> >
>
>