ADODB.Connection

[Aaron Bertrand - MVP]

> Is there an advantage of one of these over the other, other than not
having

> to know the physical path?
>
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("/_db/my.mdb") & ";"
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> Source="d:\inetpub\wwwroot\_db\my.mdb;"

No. However, the advantage isn't just about being oblivious to the path at
step 1, it's also about being immune to changes to the path indefinitely.
With the first method, your ISP could change the folder structure of its
webroot 80 times, and you wouldn't be affected...

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Roland Hall]

Is there an advantage of one of these over the other, other than not having
to know the physical path?

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/_db/my.mdb") & ";"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
Source="d:\inetpub\wwwroot\_db\my.mdb;"

--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.

[McKirahan]

"Roland Hall" <nobody@nowhere> wrote in message
news:ucR3ZgDwDHA.2072@TK2MSFTNGP10.phx.gbl...

> Is there an advantage of one of these over the other, other than not

having

> to know the physical path?
>
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("/_db/my.mdb") & ";"
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> Source="d:\inetpub\wwwroot\_db\my.mdb;"
>
> --
> Roland
>
> This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose.
>

Nope; MapPath() "Returns the full physical path ...".

Note, you mistyped "Date Source=" above.

[Bob Barrows]

Roland Hall wrote:

> Is there an advantage of one of these over the other, other than not
> having to know the physical path?
>
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("/_db/my.mdb") & ";"
> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> Source="d:\inetpub\wwwroot\_db\my.mdb;"

I suppose there might be a nanosecond or two saved by not having to run the
MapPath function, but ...

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Roland Hall]

"Aaron Bertrand - MVP" wrote:

> > Is there an advantage of one of these over the other, other than not

> having

> > to know the physical path?
> >
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> > Server.MapPath("/_db/my.mdb") & ";"
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> > Source="d:\inetpub\wwwroot\_db\my.mdb;"

>
> No. However, the advantage isn't just about being oblivious to the path

at

> step 1, it's also about being immune to changes to the path indefinitely.
> With the first method, your ISP could change the folder structure of its
> webroot 80 times, and you wouldn't be affected...

Good answer. I had seen quite a few people use MapPath and I usually don't
so I wondered what the benefit would be and this is obviously a good reason
to use it.

Thank you.

--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.

[Roland Hall]

"McKirahan" wrote:

> "Roland Hall" wrote:

> > Is there an advantage of one of these over the other, other than not

> having

> > to know the physical path?
> >
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> > Server.MapPath("/_db/my.mdb") & ";"
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> > Source="d:\inetpub\wwwroot\_db\my.mdb;"

>
> Nope; MapPath() "Returns the full physical path ...".
>
> Note, you mistyped "Date Source=" above.

Ah, the infamous typo. Somehow I have a feeling it won't be my last.
Thank you.

[Roland Hall]

"Bob Barrows" wrote:

> Roland Hall wrote:

> > Is there an advantage of one of these over the other, other than not
> > having to know the physical path?
> >
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> > Server.MapPath("/_db/my.mdb") & ";"
> > strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date
> > Source="d:\inetpub\wwwroot\_db\my.mdb;"

>
>
> I suppose there might be a nanosecond or two saved by not having to run

the

> MapPath function, but ...
>
> Bob Barrows

I thought it might have some overhead but didn't think it would be
traumatic, even if you made a lot of calls to the database.
Thank you.