>>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).
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement