SQL Too many client tasks

[Jan Schenkel]

--- "Peter Bower, M.D." <pbower at soundmedicine.com>
wrote:
> I am reading and writing to an access database using
> revolution.
> All seems to go well, then after 10 transactions I
> get a "(ODBC Microsoft Access Driver) too many
> client tasks" error.
> After each open command to read or write to the
> database I always have a close statement.
> 
> Any thoughts as to what I'm doing wrong?
> 
> Peter J. Bower, M.D.
> 

Hi Peter,

What exactly do you close? The connection? Or the
result set cursors? You don't have to close the
connection after each query, but you should always
close the cursor before executing another query.

Jan Schenkel.

Quartam Reports & PDF Library for Revolution
<http://www.quartam.com>

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)


       
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469