Can I use datasource=.\\SQLEXPRESS or do I need to now use: machinename\\SQLEXPRESS

c# string connection sql-server-2008-express
tdjfdjdj picture tdjfdjdj · May 26, 2011 · Viewed 12.5k times · Source

Can I still use datasource=.\SQLEXPRESS or do I need to change it to : machine_name\SQLEXPRESS for a local instance of SQL Server 2008 Express in C#?

My connection string worked fine in SQL Express 2005, but with the same settings no longer works for 2008.

Answer

Oded picture Oded · May 26, 2011

Assuming the instance name is indeed SQLEXPRESS, using .\SQLEXPRESS will work locally.

Use the SQL Server Configuration Manager to find out the correct instance name.

Related questions

Connection string with relative path to the database file

I load data from sdf database in winforms App. I use full path to the database file . Example : conn = new SqlCeConnection { ConnectionString ="Data Source=F:\\My Documents\\Project1\\bin\\Debug\\Database.sdf" }; I d like use a relative path to …

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More
Convert int to string?

How can I convert an int datatype into a string datatype in C#?

Read More