[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

[akalana]

I am trying to find a way to drop the connection that Access has with
this error message:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

I realize it is related to the OBDC driver string.
So I have resorted to using OLEDB string.

Using Frontpage, I know we can edit the string.
Using FPs database connection wizard, I selected to create a custom
definition:
Provider=Microsoft.Jet.OLEDB.4.0; Source=htdocs\fpdb\aetmain.mdb
I keep getting either ISAM error, or authentication failed when I try
to verify this connection in Frontpage.
Is there a defined way for setting the OLEDB driver string in
Frontpage through the custom definition of FP database connection
wizards or creating a custom DSN file for FP?

 

[Jim Buyens]

-----Original Message-----

I am trying to find a way to drop the connection that
Access has with this error message:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

I realize it is related to the OBDC driver string.

Actually, I'd say it has to do with:

o Too many hits in too short a time, or
o ASP or ASP.NET pages that don't close ADODB.Connection,
ADODB.Command, and ADODB.Recordset objects.

So I have resorted to using OLEDB string.

Using Frontpage, I know we can edit the string.
Using FPs database connection wizard, I selected to
create a custom definition:
Provider=Microsoft.Jet.OLEDB.4.0;
Source=htdocs\fpdb\aetmain.mdb
I keep getting either ISAM error, or authentication
failed when I try to verify this connection in Frontpage.
Is there a defined way for setting the OLEDB driver
string in Frontpage through the custom definition of FP
database connection wizards or creating a custom DSN
file for FP?

The corrrect syntax is:

Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\Nwind.mdb;

Note the use of Data Source rather than just Source, and
that DataSource specifies a physical file name on the
server.

For more info about OLEDB conenction string properties,
browse:

http://msdn.microsoft.com/library/en-
us/dnacc2k/html/adoproperties.asp

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------