ADO Performance Question

[MDW]

Hey there,

I connect to Access 2000 using ASP/ADO (surprise
surprise). Currently, my connection string looks like this:

Set DB = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath(strDatabaseLocation)
DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " &
DBPath

However, I've also seen this variation as well:

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open DBPath

Is either one of those methods (or another form)
preferable for any reason? Be it speed, support, etc?

[Aaron Bertrand [MVP]]

ODBC has a little extra overhead. It's also been deprecated.
See [url]http://www.aspfaq.com/2126[/url] for more information.
Also see the fourth paragraph, under "Summary", in
[url]http://support.microsoft.com/?kbid=222135[/url]

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




"MDW" <anonymous@discussions.microsoft.com> wrote in message
news:029901c3bc53$37b98b40$a101280a@phx.gbl...

> Hey there,
>
> I connect to Access 2000 using ASP/ADO (surprise
> surprise). Currently, my connection string looks like this:
>
> Set DB = Server.CreateObject("ADODB.Connection")
> DBPath = "DBQ=" & server.mappath(strDatabaseLocation)
> DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " &
> DBPath
>
> However, I've also seen this variation as well:
>
> set conn=Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open DBPath
>
> Is either one of those methods (or another form)
> preferable for any reason? Be it speed, support, etc?

[McKirahan]

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:udhnpbFvDHA.3224@tk2msftngp13.phx.gbl...

> ODBC has a little extra overhead. It's also been deprecated.
> See [url]http://www.aspfaq.com/2126[/url] for more information.
> Also see the fourth paragraph, under "Summary", in
> [url]http://support.microsoft.com/?kbid=222135[/url]
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "MDW" <anonymous@discussions.microsoft.com> wrote in message
> news:029901c3bc53$37b98b40$a101280a@phx.gbl...

> > Hey there,
> >
> > I connect to Access 2000 using ASP/ADO (surprise
> > surprise). Currently, my connection string looks like this:
> >
> > Set DB = Server.CreateObject("ADODB.Connection")
> > DBPath = "DBQ=" & server.mappath(strDatabaseLocation)
> > DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " &
> > DBPath
> >
> > However, I've also seen this variation as well:
> >
> > set conn=Server.CreateObject("ADODB.Connection")
> > conn.Provider="Microsoft.Jet.OLEDB.4.0"
> > conn.Open DBPath
> >
> > Is either one of those methods (or another form)
> > preferable for any reason? Be it speed, support, etc?

I now use:

Set objADO = CreateObject("ADODB.Connection")
objADO.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath(database.mdb)

Actually, I use:

Const cDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Const cMDB = "database.mdb"
Set objADO = CreateObject("ADODB.Connection")
objADO.Open cDSN & Server.MapPath(cMDB)

Watch for word-wrap.