>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?
Is this a connection to a remote machine? If so make sure the remote machine enables remote connections - by default that's disabled. You may also have to check what port the server is listening on - typically that's 1433, but it's changeable from the server end. You can specify a different port as part of the connection string (ie. ipordomain:port syntax).
Best thing to do is connect with an interactive SQL client like SQL Server Management studio and see whether that works first. You might get additional error info in that case as well.
+++ Rick ---