ODBC dbase Driver Error.

Craig Hastings · Joined: 03 Nov 2004 Posts: 6 Location: Toronto Canada

I am getting this error about every three days, I have to restart Firstspot to clear the error, we see that error can anyone give me any hints. Users see this in there web browser, and I see it in the status window.

Warning: odbc_connect(): SQL error: [Microsoft][ODBC dBase Driver] Too many client tasks., SQL state 08004 in SQLConnect in c:\program files\firstspot\cfgmgr\user_status.php on line 88
connection failed!
_________________
Craig Hastings
Toronto,Canada.

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

This should be due to the fact that your system has a relatively high concurrent access, and the dbase datasource has some limitations on concurrency.

Your best bet is to switch the datasource to either MySQL and SQL server.
_________________
~ Patronsoft Limited ~

hubcomputers · Joined: 19 Jan 2006 Posts: 5

Craig,

I have a similar problem with v4 and I'm wondering if upgrading fixed your problem?

Troy McLennan
troy@hub.mb.ca

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

No. See http://patronsoft.com/forum/viewtopic.php?t=984 .
_________________
~ Patronsoft Limited ~