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

Connect to SQL Server 2000 from command line interface

Hi,
I need to implement command line interface to SQL Server 2000 ...
I have no idea from where to begin... What programming environment? What language? From where and how to connect to db? I'll be glad to accept any ideas.
Thank youosql, isql ?|||sorry, i didn't understand your answer...|||Originally posted by yuliam
sorry, i didn't understand your answer...

BOL (books on line):

The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft SQL Server 2000.

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.|||Thank you very mach!!!
Now i have a clue from were to start