Re: ODBC microsoft access driver

I quickly learned access if NOT the DB to use for web applications. My
guess here is that you were testing your application and it bombed
somewhere in the middle, you tried it again and got this error right?
Because when your app bombed the first time it left the connection open
and also "locked" the database. You will have to wait several minutes
for the lock to be auto cleared by the server.

Here are a few reasons to NOT use access;
1. The locking issues that you are experiencing
2. Its unstable and easy to corrupt
3. Access has limited concurrent connections. If you have too many
users accessing it you will get errors.

If you can get mysql (there are free versions available) I would use
that. Its way faster than access, you can have many more concurrent
connections, and it's VERY stable. You can get a web interface that
allows you to do almost everything you could do through access, like
view rows, edit rows, delete rows, add columns, etc. I was a die hard
MS Access fan for small web sites myself but when those small websites
started getting a little more popular I started having major database
problems. I also had random problems with locking and tables being
corrupt.

Since I've changed everything over to MYSQL, I have had no problems,
and my sites performance was immediately boosted. I know there are
probably a dozen people that are going to reply back stating otherwise
but the facts don't lie, and my experience with both db's proves MYSQL
is a much better choice.

Jeremy Reid
http://hgtit.com

.

Relevant Pages

  • Re: Experiences with mysql_pconnect?
    ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... especially when the server is remote as it requires multiple calls to MySQL. ... queries that you execute on a regular basis, preparing it and then ...
    (comp.lang.php)
  • Re: Experiences with mysql_pconnect?
    ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... > Using prepared statements will probably speed up your app a lot. ... especially when the server is remote as it requires multiple calls to MySQL. ...
    (comp.lang.php)
  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... His hoster says that Apache server is under significant load. ... Using apc is pretty much transparent, but memcached will require modifying your database abstraction layer using the memcached functions. ... With persistent connections, you must have the maximum number of connections *ever* required allocated *all of the time* - even if no one is using your server. ...
    (comp.lang.php)
  • Re: XP speed
    ... The slowness is not be purely an Internet Explorer issue. ... I suppose you could use IE to browse shared folders instead of using Windows ... just like you can use Windows Explorer to browse web sites. ... have more concurrent connections, that only works on sites that do not limit ...
    (microsoft.public.windowsxp.newusers)
  • Re: [PHP-DEV] [PHP4] Logging native PHP function calls
    ... X (number of mysql usernames) ... If you really have 150 MaxClients in httpd.conf and 140 mysql ... 15,600 mysql connections is a LOT of connections, and will take a LOT ... I've never tried to run a server with 140 mysql usernames, ...
    (php.general)