Accessing a Local Database
Connecting to local databases at remote sites is a classic chicken and egg proposition. If must know where things are before you can access them. How do you know where the information is that tells you where the data is?
I have ended up using a downloaded XML file that local sites can modify. It is an extra step, but it does allow multiple sites to have different configuration. I put this file in a hard coded location like c:\javadeliver or etc\javadeliver and have the program check both places for it.