Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duverney1
Starting Member
1 Post |
 Posted - 2013-04-02 : 13:08:10
|
| I want to do a select from a single table, but if I load more then 1,500,000 registers ADODB trigger an error.When i do the same query in query analizer everything is ok. I think is my recordset configuration.This is my recordset declaration Set Sal = New ADODB.Recordset Sal.CursorType = adOpenStatic Sal.CursorLocation = adUseClient Sal.LockType = adLockBatchOptimistic If Not IsMissing(PageSize) Then If IsNumeric(PageSize) Then Sal.PageSize = PageSize Sal.Properties("Initial Fetch Size") = PageSize End If End If Sal.Open QueryS, CNN, 0, adLockOptimisticDoes anybody has a solution ?By the way this is VB6 Code |
|
|
|
|
|
Query size error