Connecting to a Remote Database from VB

[binujosep]

I am devoloping an Application to automate a Store using Visual Basic and SQL Server7.0

My client has a website providing information of the products availabe in his store so that the users can order for products from the website

The problem i face is ..

I have the stores database on the server which is connected on the LAN . I can add modify and delete and perform any database opertion from my Visual basic application installed at my clients store

Now the clients website database is in a remote location ( on a webserver located at some place) he can only access it through a browser.

How can i update the database in the remote location when i make changes in the database which is on the LAN from visual basic

please help me with a soloution

[kovan]

you can set your connection string to use the SQL server's IP

where you have like the SQL SERVER NAME in your connection
change it to the IP address