Connection String For Sql Server

[bhagawatshinde]

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.

[kvprajapati]

Find suitable connection strings for different database products.

[bhagawatshinde]

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

[TheJohnSpecko]

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.

[shiva07]

conection string for sql

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