I am getting this error on all dynamic pages of my web site. It has only recently been happening more and more regularly.
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
The site is ASP and uses a number of Access 2000 databases.
My host is saying their is probably a problem with my database connections but it has worked fine for many months up to recently and i have not changed any database connection code.
Any help appreciated.
Abhishek Reddy posted this at 11:00—27th April 2002.
He has: 3,284 posts
Joined: Jul 2001
Have you closed all connections properly?
detox posted this at 13:06—27th April 2002.
They have: 571 posts
Joined: Feb 2001
this is all I could find with a quick search of forums:
" try using an OLEDB connstring rather than an ODBC connstring for MS Access."
However having never seen this error message personally I cannot say too much. Will have a look. Do you have the error code number?
Detox -TWF Moderator
DetoxDezigns - freelance
Peter J. Boettcher posted this at 13:09—29th April 2002.
They have: 812 posts
Joined: Feb 2000
Make sure you're closing all your connections, and use OLEDB instead of ODBC. Maybe your host has upgraded the ADO version on the server and it has affected your code?
PJ | Are we there yet?
pjboettcher.com
detox posted this at 13:47—30th April 2002.
They have: 571 posts
Joined: Feb 2001
still getting that message?