I have a database that is stored on a remote machine.
In my application i have used connection string with
IP address of that remote machine. Now, the problem is
every time the remote machine is turned on it has a new
IP address. Is there any way that i can get that newly
generated IP address stored in connection string automatically
every time i try to connect to database.
Here's my connection string :
Data Source=xxx.xxx.xxx.xxx,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
NOTE : Its not a web application.