>>Should each cursoradapter object have its private connection handle ?
>When several CursorAdapter objects share the same ODBC connection/statement handle, CursorFill for some of them may fail because another CursorAdapter haven't finished fetch. To workaround this problem set FetchSize=-1 for all CursorAdapter objects or use dedicated ODBC connection/statement handle for each of them. I personally prefer the second.
Hi Aleksey
I set FetchSize=-1 for all CursorAdapter objects and now the form work as I expected. Thanks!
I am curious why you prefer second method (dedicated ODBC connections).
For me the method has two seriuos disadvantages:
- it is not comfortable in case when several cursors participate in the same transaction (you have to bind conections using token)
- it seems that form with many cursor will consume more SQLServer resources than it is needed (I wonder if it could cause exceeding MSDE limits).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only