Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection is used by another hstmt.
Message
De
04/11/2004 03:03:12
 
 
À
03/11/2004 13:36:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
00957561
Message ID:
00957973
Vues:
16
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform