Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection handle error
Message
De
02/08/2011 14:08:45
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01519893
Message ID:
01519933
Vues:
32
ok
but i should mention that i have the connection string in a "connection" named Upsize
Handle=SQLCONNECT('Upsize','','',.T.)

IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
  browse
   MESSAGEBOX("Success")
ELSE
	MESSAGEBOX("Failed")
   
ENDIF
Resulting Error / Handle is invalid

Handle = SQLSTRINGCONNECT("DSN=dpsal;UID=Josephine;APP=Microsoft Visual FoxPro;WSID=HP6PQ8;DATABASE=RemoteAccess;Network=DBMSLPCN;Address=HP6PQ8\SQLEXPRESS,1433;
Trusted_Connection=Yes;Regional=Yes;UseProcForPrepare=0")
IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
  browse
   MESSAGEBOX("Success")
ELSE
	MESSAGEBOX("Failed")
   
ENDIF
REsulting Error / Data type Mis-match

the error points to the following line
IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform