>>>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.
>>The error occur into the a View or into a SPT command ?
>>You can put the code piece that generates the error?
>
>The Error occur in an SPT command. The Code is difficult to write here, because of our Framework. Bud I try to:
>

>this.ConString	= "SERVER=Sql-server;DATABASE=ivs2000;TRUSTED_CONNECTION=Yes"
>lcConName       = this.ConName
>lcODBCDriver    = this.ODBCDriver
>CREATE CONNECTION &lcConName CONNSTRING "DRIVER="+lcODBCDriver+";"+this.ConString
>
>lnConHdl = sqlConnect(this.ConName, .t.)
>sqlsetprop(lnConHdl,"IdleTimeout",0)
>
>sqlExec(lnConHdl, "select max(aufneuanlage) as neuanlage from auftragseingang", "curTest")
>
>

the line:

CREATE CONNECTION (m.this.ConName) CONNSTRING ....

redefine ConName at runtime.

Difficult to say it with certainty,
but task that if VFP has used this with a view, probably it has gone in confusion, or it is appeared a rare bug.
The error has this meant:
- VFP in a ODBC command has used a statement handle together
to a incorrect session handle.

A solution is that one to analyze the Log of the ODBC API commands.

Fabio