Convert an Access database to SQL

  • Thread starter Thread starter cory
  • Start date Start date
(e-mail address removed) (Jim Allensworth) wrote in
AFIK, you can't use DAO with asp - only ADO. Classic ASP anyway.
Click to expand...

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.
 
(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.
Click to expand...
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
 
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
 
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
 
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.
 
Back
Top