asked on vfp9 sql remote connection
HI Experts
I am using the following connection string from fvp9 to connect to a remote sql database.
FMS_SERVERIP= '235,256,258,99' my remote sql server ip
lcStr = "Driver={SQL SERVER};Server=&FMS_SERVER
try
lnHandle = Sqlstringconnect(lcStr)
lnResult = SQLExec(lnHandle, "SELECT * FROM message ", "cOutData1")
CATCH
wait window 'no sql connection'
ENDTRY
it works fine but if I lost the internet connection it does not goto my catch option instead it comes back with Microsoft SQL Server Login connction failed error
when I click ok it pops up another screen and gives me the oprion to change login id and password then try to connect again.
What I would like to happend when the connection fails is to goto catch option , wait window 'no sql connection'
Please help
Thanks
I am using the following connection string from fvp9 to connect to a remote sql database.
FMS_SERVERIP= '235,256,258,99' my remote sql server ip
lcStr = "Driver={SQL SERVER};Server=&FMS_SERVER
try
lnHandle = Sqlstringconnect(lcStr)
lnResult = SQLExec(lnHandle, "SELECT * FROM message ", "cOutData1")
CATCH
wait window 'no sql connection'
ENDTRY
it works fine but if I lost the internet connection it does not goto my catch option instead it comes back with Microsoft SQL Server Login connction failed error
when I click ok it pops up another screen and gives me the oprion to change login id and password then try to connect again.
What I would like to happend when the connection fails is to goto catch option , wait window 'no sql connection'
Please help
Thanks
FoxProMicrosoft SQL Server
Last Comment
Olaf Doschke
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
IF lnHandle > 0
WAIT WINDOW "There is connection"
ELSE
WAIT WINDOW "There is no connection"
ENDIF