cannot open Large Table with Image fields | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cannot open Large Table with Image fields

i have one table with this structure
fileID Bigint
FileContent Image this table have 500,000 record. i want open it. but i cannot open it and timeout. With rstFilesContent
.ActiveConnection = CnOffice
.CursorLocation = adUseServer
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Source = "Select * From FilesContent Order By FileID"
.Properties("preserve on commit") = True
.Properties("preserve on abort") = True
.Open
End With
Cursortype must be keyset becuase i use move function
You are retrieving 500,000 rows with images ???
Looks pretty much like a connection or commandtimeout in ADO.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx might be interesting
Frank
http://www.insidesql.de
http://www.familienzirkus.de
]]>