Convert an Access database to SQL

[David W. Fenton]

(e-mail address removed) (Jim Allensworth) wrote in

AFIK, you can't use DAO with asp - only ADO. Classic ASP anyway.

I should have said ODBC.

The URL you posted in another thread pretty clearly confirms the
other things I've said, that a Jet back end can handle far more
users if you conserve connections. It stands to reason, of course.

It is a case, though, where the introduction of ADO was a real
advance. Access with Jet data was *not* such a case -- that was a
case where ADO has no value whatsoever in the vast majority of
scenarios.

 

[Jim Allensworth]

(e-mail address removed) (Jim Allensworth) wrote in


I should have said ODBC.

The URL you posted in another thread pretty clearly confirms the
other things I've said, that a Jet back end can handle far more
users if you conserve connections. It stands to reason, of course.

It is a case, though, where the introduction of ADO was a real
advance. Access with Jet data was *not* such a case -- that was a
case where ADO has no value whatsoever in the vast majority of
scenarios.

It is an important concept that with ASP - unlike Access - there is no
connection maintained. The database is hit and immediately released.
Assuming a reasonably well constructed SQL this is very fast - in the
fraction of a second neighborhood. Of course the server comes into
play as well. Along with properly indexed tables.

- Jim

 

[Larry Linson]

Just what is the RSFast that is mentioned? I followed the link and it talked
about how to use it, but not exactly what it _is_ nor where/how one might
obtain it.

Larry

 

[Jim Allensworth]

Just what is the RSFast that is mentioned? I followed the link and it talked
about how to use it, but not exactly what it _is_ nor where/how one might
obtain it.

It's an ASP library that facilitates caching. Here is an
intro/overview to it...
http://www.learnasp.com/learn/rsfast-intro.asp

Here is the actual library ...
http://www.learnasp.com/learn/rsfast-lib.asp

I haven't used it, but it looks quite interesting - especially for us
Jet users.

- Jim

 

[Larry Linson]

Thanks, Jim. I will take a closer look at it. It may be just what is needed
for some website enhancements for my user group.

Larry

 

[Art]

1) My ISP is www.brinkster.com and it supports MDB-database (and SQL
Server for some extra money)
2) Usually traffic comes from querying database: in case of .NET it is
possible to load entire database into disconnected recordsets, then
close MDB-database and feel good about any number of requests. Of
course, in case of update you still may open MDB, update and close but
that will not overload any system. Well, it is probably too late
advice for this particular app but next time you will know. Why to pay
for SQL if .Net provides disconnected recordsets?

See my site (disconnected from MDB): www.BuyFineArtOnline.com

Leo.