In practically all the books i have about visual basic 2005 databases,all examples speaks about a database that exists on a local server. But what about a database that is on a server on a remote computer that is only reachable via the internet. For example:
I have a database that exists on the sql server 2005 on my desktop.
This desktop is connected to the internet. I have a laptop on wich i have my ADO.NET database program (in vb 2005). This laptop has a wireless connection with the internet. Now i like to connect from my laptop to the database on my desktop via the internet. The problem is that the IP address of my desktop is a dynamic IP address. How do i have to construct my connectionstring ? I heard about a program that solves the problem of dynamic IP addresses. Is it possible to use this program in relation to my ADO.NET program, and how do I put the address to my database on the server on my desktop in the connectionstring ?

There are dynamic DNS services that will change a url to the dynamic IP automatically. You then can just set the "server" of your connection string to the domain and as long as the IP stays up-to-date it will work.

Depending on what your connection is at home (cable/dsl) you may have a much more statis IP than you think. I have a cable modem which does have a dynamic IP but I have my domain pointed at it and it very seldom changes. Typically, if the modem is connected all the time it won't change IPs. Usually I'll see it change when I turn it off for more than a few minues. It has mainted the IP thru restarts, short power outages, etc.

(Please note this disclaimer: Depending on your agreement with your ISP you might be violating your service contract by running a server or server-like services [i.e. database] on your connection.)

You do need to expose your server at home thru your internet connection.

If your computer is connected directly than you don't need to change anything with the hardware but you will likely need to change your OS firewall settings to allow requests for SQL server to come in.

If you have a router on your connection then you need to open the SQL port to point to your desktop at home. You'll have to refer to your router instructions for details.

The standard SQL server port is 1433. Just keep in mind that you are opening your database server to the world so make sure you have very string passwords for the accounts (most importantly the SA account).

-Peter

generally u use Public IP Address whn u want to host a remote server over the internet
try tht