hi i'm having trouble with my asp site that runs on an access 2000 
database. my site is located at http://www.hikki-zone.com

When i load default.asp i recieve the following error "[Microsoft][ODBC 
Microsoft Access Driver] Too many client tasks."

Now this error is coming from /inc_top.asp, line 7. This line in the asp 
file is the statement that opens up a connection to the database. And I 
know the connection string is correct because it works on my machine 
(win2000 and IIS 5.0). What I had found out about this error is that I'm 
trying to access a lot of information from the database....and this site 
has worked perfectly before on other hosts and the host we are with now. I 
started getting these errors one day out of the blue. I had not even 
altered the asp code! Now what i am accessing is information from one 
table and one recordset which has 122 fields. I think this is the root of 
the problem. 

Regards

David


The asp code below is from "config.asp" which contains information such as 
the database connection string and SQL statements.
<%
on error resume next
Session.LCID = 5236 '## Do Not Edit
Response.Buffer = true

dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do 
Not Edit

'##########################################################################
#######
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or 
mysql)
'##########################################################################
#######
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & 
Server.MapPath("../private/2002.mdb") '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & 
Server.MapPath("/cgi-bin/mwp/db2002.mdb") '## MS Access 2000 using virtual 
path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & 
Server.MapPath("/_hide/2002.mdb") '## MS Access 2000
'strConnString = "driver={SQL 
Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME
" '## MS SQL Server 7
'strConnString 
= "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DAT
ABASE_NAME" '## MySQL

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

strWebMaster = "admin"
strShowImagePoweredBy = "0"



	'## Forum_SQL
	strSql = "SELECT C_STRVERSION "
	strSql = strSql & ", C_STRFORUMTITLE "
	strSql = strSql & ", C_STRCOPYRIGHT "
	strSql = strSql & ", C_STRTITLEIMAGE "
	strSql = strSql & ", C_STRHOMEURL "
	strSql = strSql & ", C_STRFORUMURL "
	strSql = strSql & ", C_STRAUTHTYPE "
	strSql = strSql & ", C_STRSETCOOKIETOFORUM "
	strSql = strSql & ", C_STREMAIL "
	strSql = strSql & ", C_STRUNIQUEEMAIL "
	strSql = strSql & ", C_STRMAILMODE "
	strSql = strSql & ", C_STRMAILSERVER "
	strSql = strSql & ", C_STRSENDER "
	strSql = strSql & ", C_STRDATETYPE "
	strSql = strSql & ", C_STRTIMEADJUST "
	strSql = strSql & ", C_STRTIMETYPE "
	strSql = strSql & ", C_STRMOVETOPICMODE "
	strSql = strSql & ", C_STRIPLOGGING "
	strSql = strSql & ", C_STRPRIVATEFORUMS "
	strSql = strSql & ", C_STRSHOWMODERATORS "
	strSql = strSql & ", C_STRALLOWFORUMCODE "
	strSql = strSql & ", C_STRALLOWHTML "
	strSql = strSql & ", C_STRNOCOOKIES "
	strSql = strSql & ", C_STRSECUREADMIN "
	strSql = strSql & ", C_STRHOTTOPIC "
	strSql = strSql & ", C_INTHOTTOPICNUM "
	strSql = strSql & ", C_STRIMGINPOSTS "
	strSql = strSql & ", C_STRHOMEPAGE "
	strSql = strSql & ", C_STRICQ "
	strSql = strSql & ", C_STRYAHOO "
	strSql = strSql & ", C_STRAIM "
	strSql = strSql & ", C_STRICONS "
	strSql = strSql & ", C_STRGFXBUTTONS "
	strSql = strSql & ", C_STREDITEDBYDATE "
	strSql = strSql & ", C_STRBADWORDFILTER "
	strSql = strSql & ", C_STRBADWORDS "
	strSql = strSql & ", C_STRDEFAULTFONTFACE "
	strSql = strSql & ", C_STRDEFAULTFONTSIZE "
	strSql = strSql & ", C_STRHEADERFONTSIZE "
	strSql = strSql & ", C_STRFOOTERFONTSIZE "
	strSql = strSql & ", C_STRPAGEBGCOLOR "
	strSql = strSql & ", C_STRDEFAULTFONTCOLOR "
	strSql = strSql & ", C_STRLINKCOLOR "
	strSql = strSql & ", C_STRLINKTEXTDECORATION "
	strSql = strSql & ", C_STRVISITEDLINKCOLOR "
	strSql = strSql & ", C_STRVISITEDTEXTDECORATION "
	strSql = strSql & ", C_STRACTIVELINKCOLOR "
	strSql = strSql & ", C_STRHOVERFONTCOLOR "
	strSql = strSql & ", C_STRHOVERTEXTDECORATION "
	strSql = strSql & ", C_STRHEADCELLCOLOR "
	strSql = strSql & ", C_STRALTHEADCELLCOLOR "
	strSql = strSql & ", C_STRHEADFONTCOLOR "
	strSql = strSql & ", C_STRCATEGORYCELLCOLOR "
	strSql = strSql & ", C_STRCATEGORYFONTCOLOR "
	strSql = strSql & ", C_STRFORUMFIRSTCELLCOLOR "
	strSql = strSql & ", C_STRFORUMCELLCOLOR "
	strSql = strSql & ", C_STRALTFORUMCELLCOLOR "
	strSql = strSql & ", C_STRFORUMFONTCOLOR "
	strSql = strSql & ", C_STRFORUMLINKCOLOR "
	strSql = strSql & ", C_STRTABLEBORDERCOLOR "
	strSql = strSql & ", C_STRPOPUPTABLECOLOR "
	strSql = strSql & ", C_STRPOPUPBORDERCOLOR "
	strSql = strSql & ", C_STRNEWFONTCOLOR "
	strSql = strSql & ", C_STRTOPICWIDTHLEFT "
	strSql = strSql & ", C_STRTOPICNOWRAPLEFT "
	strSql = strSql & ", C_STRTOPICWIDTHRIGHT "
	strSql = strSql & ", C_STRTOPICNOWRAPRIGHT "
	strSql = strSql & ", C_STRSHOWRANK "
	strSql = strSql & ", C_STRRANKADMIN "
	strSql = strSql & ", C_STRRANKMOD "
	strSql = strSql & ", C_STRRANKLEVEL0 "
	strSql = strSql & ", C_STRRANKLEVEL1 "
	strSql = strSql & ", C_STRRANKLEVEL2 "
	strSql = strSql & ", C_STRRANKLEVEL3 "
	strSql = strSql & ", C_STRRANKLEVEL4 "
	strSql = strSql & ", C_STRRANKLEVEL5 "
	strSql = strSql & ", C_STRRANKCOLORADMIN "
	strSql = strSql & ", C_STRRANKCOLORMOD "
	strSql = strSql & ", C_STRRANKCOLOR0 "
	strSql = strSql & ", C_STRRANKCOLOR1 "
	strSql = strSql & ", C_STRRANKCOLOR2 "
	strSql = strSql & ", C_STRRANKCOLOR3 "
	strSql = strSql & ", C_STRRANKCOLOR4 "
	strSql = strSql & ", C_STRRANKCOLOR5 "
	strSql = strSql & ", C_INTRANKLEVEL0 "
	strSql = strSql & ", C_INTRANKLEVEL1 "
	strSql = strSql & ", C_INTRANKLEVEL2 "
	strSql = strSql & ", C_INTRANKLEVEL3 "
	strSql = strSql & ", C_INTRANKLEVEL4 "
	strSql = strSql & ", C_INTRANKLEVEL5 "
	strSql = strSql & ", C_STRSIGNATURES "
	strSql = strSql & ", C_STRSHOWSTATISTICS "
	strSql = strSql & ", C_STRLOGONFORMAIL "
	strSql = strSql & ", C_STRSHOWPAGING "
	strSql = strSql & ", C_STRSHOWTOPICNAV "
	strSql = strSql & ", C_STRPAGESIZE "
	strSql = strSql & ", C_STRPAGENUMBERSIZE "
	strSql = strSql & ", C_STRFULLNAME"
	strSql = strSql & ", C_STRPICTURE"
	strSql = strSql & ", C_STRSEX"
	strSql = strSql & ", C_STRCITY"
	strSql = strSql & ", C_STRSTATE"
	strSql = strSql & ", C_STRAGE"
	strSql = strSql & ", C_STRCOUNTRY"
	strSql = strSql & ", C_STROCCUPATION"
	strSql = strSql & ", C_STRBIO"
	strSql = strSql & ", C_STRHOBBIES"
	strSql = strSql & ", C_STRLNEWS"
	strSql = strSql & ", C_STRQUOTE"
	strSql = strSql & ", C_STRMARSTATUS"
	strSql = strSql & ", C_STRFAVLINKS"
	strSql = strSql & ", C_STRRECENTTOPICS"
	strSql = strSql & ", C_STRHOMEPAGE"
	strSql = strSql & ", C_STRNTGROUPS"
	strSql = strSql & ", C_STRAUTOLOGON"
	strSql = strSql & ", C_ADMINPOLLS"
	strSql = strSql & ", C_USERPOLLS"
	strSql = strSql & ", C_ACTIVEPOLL"
	strSql = strSql & ", C_JOKEOFTHEWEEK"
	strSql = strSql & ", C_FORUMSTATUS"
	strSql = strSql & ", C_STRFLOODCHECK"
	strSql = strSql & ", C_STRFLOODCHECKTIME"
	
	strSql = strSql & " FROM " & strTablePrefix & "CONFIG "
	set rsConfig = my_Conn.Execute (strSql)

%>

note that some irrelevant code from this page was not included here.