Hi I am developing an application that has two parts 1) client machine 2) server i.e. (internet web data). i want to access the table on the server (internet) how i can use the connection string. how i can connect to client to server

can anybody help me.

Find suitable connection strings for different database products.

thanks for reply adatapost,
which connection string should use for sqlserver 2005. really confuse can you help please

There is a link on the page that adatapost gave to the syntax for connection strings for SQL Server 2005. If you don't have any experience with connection strings, here is a good source to learn it.

conection string for sql

<connection string>
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
</connection string>