Environment versions
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.
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