[Microsoft][ODBC Microsoft Access Driver] System resource exceeded

odbc_pconnect() [function.odbc-pconnect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLConnect

we got the error with access 2000 database and PHP as prog. language .

we created dsn for the connection.

reboot solves the problem. but we need another solution better than this.

You might be running a query that is returning too many records.

Try limiting the query by usng the WHERE clause. Try adding more memory to your computer

Also shifting to SQL Server 2005 for larger databases would improve performance.

Regards,

http://www.Designing-Systems.com

|||You might also want to check out that you do not keep creating new connections instead of reusing existing ones. Check your PSP settings
(if you haven't already) and see whether you have pooling support from PHP or ODBC driver manager.|||

Hi there,

we solved this problem after converting access db to mysql. It solves problem for this.

thanks

|||

If the problem is any of the problems suggested by the above posters, then shifting underlying database representation will just defer the problem until your database gets larger. While your current solution has clearly reduced the pressure to fix the problem, looking into reducing query load, connection usage, and memory overhead on the client side will certainly be beneficial for building a strategy to grow your database.

Hope this helps,

John (MSFT)

|||

We solved this issue. Please close this thread.

Thank you

Jitendra Chavan