Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection handle error
Message
 
To
02/08/2011 10:58:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01519893
Message ID:
01519907
Views:
43
>*Handle=SQLCONNECT('Upsize','','',.T.)
>
>
>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")
>
>
>1st one is telling me handle error and im following the syntax
>
>SQLCONNECT([cConnectionName | cDataSourceName [, cUserID [, cPassword ]][, lShared]])
>(Connection Name/or datasource, userid,password)
>
>2nd is telling me a data type mis match and this is my connection string copied from connection in foxpro.
>
>Id love for some help on this im trying to connect my SQL database to my foxpro program thanks

Check WHY you get error with AERROR():
TEXT TO lcConnectioString NOSHOW PRETEXT 15
     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
ENDTEXT

Handle = SQLSTRINGCONNECT(lcConnectioString)
IF Handle < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform