RecordSet Limitations ? Any alternatives in ASP ?
Lakshmikanth | Posted 2:22am 29. July 2010 Server Time |
Hi.
This below SQL works fine if # of records are less than 3000. If # of records exceeds 3000 i get "internal server error". Is there a limit for RecordSet Object ? If so, what is the alternative. I need to displaya all records on web page by reading Access table.
' Below code works fine all other conditions.
strSQL1 = "SELECT ccode, cname, castinfo_additionalinfo, FROM CInfo;"
FilePath = Server.MapPath("ad\cd.mdb")
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=" & FilePath
Set rstDBEdit = Server.CreateObject("ADODB.Recordset")
rstDBEdit.Open strSQL1, connectstr, adOpenKeyset, adLockOptimistic, adCmdText |
