Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection handle error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01519893
Message ID:
01519919
Views:
32
>>>>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
>>>>
>>>
>>>when i click the button nothing happens...ill figure something out thanks
>>
>>If you didn't get any error message than your connectiot is OK.
>
>You can add ELSE case with this code
>
>IF Handle < 0 
>  ...
>
>ELSE
>   =messagebox('The connection handle is valid and = ' + transform(Handle))
>ENDIF
Why?
If the connection is valid I'll continue with the code :o)
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