Remote Server

[rothj0hn]

How can i access a sql server that is not connected in my network, but connected to the internet (w/ static IP)?

[honeybee]

I would think the same way you access a server on your network. For the server name you can either use the IP address or the hostname and then set the other connection string parameters accordingly.

.

[rothj0hn]

will it affect the speed of manipulation of data? someone told me to use a web service? which one is faster and better to use?

[honeybee]

If it's over the internet, the speeds would typically be lesser than what you get on the intranet or LAN. If you want to improve the speeds for fetching/updating data, you would have to look at the UI design and navigation, and check the data access code. For e.g. after the user logs in and goes to the order management screen, it would not be a good idea to show him all the orders at the start. Instead you can ask the user to specify some search criteria and make him click a button, which then fetches the necessary records. Also while updating, you should only pass data that needs to be updated, instead of passing everything, changed or not.

Please note this is general advice. Any particular steps you take will have to be checked with the specifics of the situation you are in.

.