Versions des environnements
Network:
Windows 2003 Server
>Hi Folks!
>
>Today I got another boring Problem.
>Im my APP, I use Views mixed with SQL Pass through. The Views and the SQL pass through Connections all shared. Now sometimes I got an ODBC Error:
>
>Original in German:
>Datenbankfehler 0: [Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt
>
>I Try to translate:
>Databaseerror 0: [Microsoft][ODBC SQL Server Driver] Connection is used by another hstmt.
>
>What is this?
Hi Jorg,
This error might indicate that you are trying to execute some command through a connection handle but VFP hasn't fetched all data for the previous execution. This usually happens when you open a view with FetchSize>0 and then try to execute something through the same connection handle.
I assume you are using VFP7 or earlier version. To avoid this error, use FetchSize=-1 for the view or execute GO BOTTOM IN ViewWorkArea before executing the next command. In VFP8, you can share the same ODBC connection without sharing the same connection handle.
Thanks,
Aleksey.
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