Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection is used by another hstmt.
Message
From
04/11/2004 03:03:12
 
 
To
03/11/2004 13:36:35
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00957561
Message ID:
00957973
Views:
15
>>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")
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform