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
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. might be interesting