What is the connection string when connecting c# to sql server 2005 express?

Question

i tried to connect sql server 2005 native client. the one embedded in visual studio, but it seems that the program does'nt accept the connection string so i downloaded sql server 2005 expres edition.

What is the connection string for sql server 2005, its syntax and how can i connect it to the program...

tnx,

Answer 1

graphics design-

http://userstyle.org/

Answer 2

(1) ConnectionString = "server=.;Database=AdventureWorks;uid=sa...

The server=. specifies that the server is local. when you know the name of your instance server, you can use its name. The above connection string assumes that you want to connect to the sql server using mixed mode authenticaction. For windows authentication check (2)

(2)- ConnectionString = "server=.;Database;=AdventureWorks;Integ... Security=True";

Hope this helps

Answer 3

This will give you all the connection strings for now and in the future...

http://www.connectionstrings.com/