Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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]
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement