>Hi Bill! I have a follow up question regarding sql and foxpro application. It turned out that client does not have static IP address so we can't configure it as a server for the sql. They don't want to pay more for a static address (It's expensive here in). How do I resolve this situation?
>
>Thanks!
>
>Stephanie :)

Stephanie -
the server can broadcast its IP address back to an intermediate host or server that does have a static IP address - then your client computers can check for that IP address on that intermediate server [each time the app is launched, for example] and then you
can put that IP address into a connection string that VFP can understand.

Sounds a bit convoluted, but its really not. Just different ..
However - one caveat - you want that dynamically assigned IP address to at least be GOOD for one day. If it changes a lot during the day then you will get into some big problems with buffered data that has lost its backend, and you'll have to program for that [easy, but not trivial].

Did you get any answer on exposing the SQL port or redirecting the SQL port to some different PORT number ?

mondo regards [Bill]