>>Got a VFP app that I'd like to take to a SQL backend, but it won't connect. Says everything is fine, but when I try to do anything on the connection it gives me an error that basically says 'Not connected'
>>
>>Research on that error generally comes back to 'port issue' so, what port does VFP default to use and is it possible to change it?
>
>You may need to run the SQL Browser service on the same machine that's hosting SQL Server. Otherwise remote computers may not be able to find the correct host\instance.
You do not *need* to use SQL Browser service is a nice to have feature, in fact we turn it off to avoid opening another port on the firewalls. You need to put the port in the server name so the client connects to the right instance, so you specify host\instance,port.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges