Web Development

Ask something
Discussion Locked

error '80040e4d' ................

0 helpful
6 replies

by rsv

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The error is:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

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

This happen on line 4

Line 1 Set NikConnObj = Server.CreateObject("ADODB.Connection")
Line 2 NikConnObj.Mode = adModeWrite %>
Line 3 #include file="connect1.inc"
Line 4 NikConnObj.Open(NikConnStr)

Where connect1.inc is

NikConnStr = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=d:/html/users/nikmartincom/database/users_new.mdb;"

Appreciate your help please!

6 replies

by emcs

Go to Microsoft's Knowledge Base '

Look at: Q247931 - INF: Authentication Methods for Connections to SQL Server in Active Server Pages.

Hope this is enough info you a.

Good luck.

dennie

by peter ritchie

the 8004e4d error deals with SQL Server authentication. The message "Too many client tasks" doesn't jive with this error code. Are you sure the error is 8004e4d?

Based on the message you're receiving ("Too many client tasks"), my guess is you've run into the limit of connections that Access/ODBC/OLEDB can handle.

You might want to look into connection pooling. One place to start researching connection pooling is MS KB article Q169470.

This discussion is closed to new replies.