<div>
lnHandle = Sqlstringconnect(lcStr) 
IF lnHandle &gt;&nbsp;0 
&nbsp; &nbsp; &nbsp;WAIT WINDOW &quot;There is connection&quot; 
ELSE 
&nbsp; &nbsp; &nbsp;WAIT WINDOW &quot;There is no connection&quot; 
ENDIF
</div>

<div>
<div class="content wysiwyg-content">
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 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;lcStr = &quot;Driver={SQL SERVER};Server=&amp;FMS_SERVERIP;Database=Group;UID=b001;pwd=b00158;Trusted_Connection=no;&quot; 
&nbsp;try 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;lnHandle = Sqlstringconnect(lcStr) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;lnResult = SQLExec(lnHandle, &quot;SELECT * FROM message &quot;, &quot;cOutData1&quot;) 
 
CATCH 
&nbsp; &nbsp; &nbsp; &nbsp; wait window 'no sql connection' 
ENDTRY 
 
it works fine but if I lost the internet connection it does not goto my catch option &nbsp;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 &nbsp;like to happend when the connection fails is to goto &nbsp;catch option , &nbsp;wait window 'no sql connection' 
Please help 
Thanks
</div>
</div>

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_SERVERIP;Database=Group;UID=b001;pwd=b00158;Trusted_Connection=no;"
 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

lnHandle = Sqlstringconnect(lcStr)
IF lnHandle &gt; 0
     WAIT WINDOW &quot;There is connection&quot;
ELSE
     WAIT WINDOW &quot;There is no connection&quot;
ENDIF

vfp9 sql remote connection

HI Experts
I am using the following connection string from fvp9 to connect to a remote sql database.

FMS_SERVERIP= &#39;235,256,258,99&#39; my remote sql server ip
	lcStr = &quot;Driver={SQL SERVER};Server=&amp;FMS_SERVERIP;Database=Group;UID=b001;pwd=b00158;Trusted_Connection=no;&quot;
 try
	lnHandle = Sqlstringconnect(lcStr)
	lnResult = SQLExec(lnHandle, &quot;SELECT * FROM message &quot;, &quot;cOutData1&quot;)

CATCH
        wait window &#39;no sql connection&#39;
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 &#39;no sql connection&#39;
Please help
Thanks

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

FoxPro

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.