Connect to SQL-Databas over TCP/IP

Hi..

I am really new in C# Programming witf h Database. My problem is:

I have a SQL Database (in an other country) and My Application has to connect it for data transfer. How can I do that? Which alternatives do i have. Should I use a Web Service?

Thanks...

Hi,

You could use the following connection string;

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOC;Initial Catalog=myDataBas;User ID=myUsername;Password=myPassword;

Obviously you will have to change the IP address to that of the server where SQL resides... also make sure you have the correct port which is the value after the comma (,) on the IP address