|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Can UNC path be used as Data Source argument in OLE DB connection string?I'm having some trouble getting this to work and can't find any reference to
whether or not it's okay. It must be legal I'm betting. Hi,
What kind of connection are you trying to establish? Show quote "GY2" <2muchspam@wherever.com> wrote in message news:%23b4gSR$NGHA.2604@TK2MSFTNGP09.phx.gbl... > I'm having some trouble getting this to work and can't find any reference > to whether or not it's okay. It must be legal I'm betting. > Thanks for helping. I working with an Ole DB connection to an Access .mdb
file on a network file server. Show quote "Val Mazur (MVP)" <group***@hotmail.com> wrote in message news:ukrpX0BOGHA.3460@TK2MSFTNGP15.phx.gbl... > Hi, > > What kind of connection are you trying to establish? > > -- > Val Mazur > Microsoft MVP > http://xport.mvps.org > > > "GY2" <2muchspam@wherever.com> wrote in message > news:%23b4gSR$NGHA.2604@TK2MSFTNGP09.phx.gbl... >> I'm having some trouble getting this to work and can't find any reference >> to whether or not it's okay. It must be legal I'm betting. >> > > GY2,
Depends if it is a database server as a SQL Server or just a kind of file server as JET (Access) (in the last it is not possible). I hope this helps, Cor Thanks for the info.
I'm trying to develop a solution which will connect with JET on a network file server. I would like to have the code 'see' on what machine it is running and use one data souce when it is on my development machine and another one (the UNC name) when it is deployed to my users. Show quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:uGhwyGFOGHA.1032@TK2MSFTNGP11.phx.gbl... > GY2, > > Depends if it is a database server as a SQL Server or just a kind of file > server as JET (Access) (in the last it is not possible). > > I hope this helps, > > Cor > > On Thu, 23 Feb 2006 10:19:36 -0500, "GY2" <2muchspam@wherever.com> wrote: ¤ Thanks for the info.¤ ¤ I'm trying to develop a solution which will connect with JET on a network ¤ file server. I would like to have the code 'see' on what machine it is ¤ running and use one data souce when it is on my development machine and ¤ another one (the UNC name) when it is deployed to my users. Below is an example connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\machinename\sharename\folder\file.mdb;" Paul ~~~~ Microsoft MVP (Visual Basic) So you are saying that I CAN use a UNC path for an Access db? I will try it
and let you know what happens. Thanks a lot. Show quote "Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message news:pbnrv1djpadh8euirh902v7d08c8ghdmjr@4ax.com... > On Thu, 23 Feb 2006 10:19:36 -0500, "GY2" <2muchspam@wherever.com> wrote: > > ¤ Thanks for the info. > ¤ > ¤ I'm trying to develop a solution which will connect with JET on a > network > ¤ file server. I would like to have the code 'see' on what machine it is > ¤ running and use one data souce when it is on my development machine and > ¤ another one (the UNC name) when it is deployed to my users. > > Below is an example connection string: > > "Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=\\machinename\sharename\folder\file.mdb;" > > > Paul > ~~~~ > Microsoft MVP (Visual Basic) Damn! It works great! And I see that it doesn't matter whether the UNC data
source string is inclosed in quotes or not. Thanks a lot! Show quote "GY2" <2muchspam@wherever.com> wrote in message news:uG6LkXJOGHA.1132@TK2MSFTNGP10.phx.gbl... > So you are saying that I CAN use a UNC path for an Access db? I will try > it and let you know what happens. Thanks a lot. > > "Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message > news:pbnrv1djpadh8euirh902v7d08c8ghdmjr@4ax.com... >> On Thu, 23 Feb 2006 10:19:36 -0500, "GY2" <2muchspam@wherever.com> wrote: >> >> ¤ Thanks for the info. >> ¤ >> ¤ I'm trying to develop a solution which will connect with JET on a >> network >> ¤ file server. I would like to have the code 'see' on what machine it is >> ¤ running and use one data souce when it is on my development machine and >> ¤ another one (the UNC name) when it is deployed to my users. >> >> Below is an example connection string: >> >> "Provider=Microsoft.Jet.OLEDB.4.0;Data >> Source=\\machinename\sharename\folder\file.mdb;" >> >> >> Paul >> ~~~~ >> Microsoft MVP (Visual Basic) > >  |
|||||||||||||||||||||||
Other interesting topics