Connecting to Database in asp.net

[srikantha_nagaraj]

Hi, In my connection string if i give Server name it will not work, But if i give with servername\SQLEXPRESS it will work. But this connection string i can't use in class as it giving an error for this. Please help me.

[Abhijit Jana]

It's because you have installed SQL Server Express Version in your System :)

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[srikantha_nagaraj]

So please solve this problem?

modified on Thursday, August 20, 2009 11:13 AM

[Ashfield]

srikantha_nagaraj wrote:

But this connection string i can't use in class as it giving an error for this.

Are we meant to guess what error? Why can't you use it, it's a valid name.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[srikantha_nagaraj]

My Connection string is "Database=QD ;Server=BHUKRK83981D\SQLEXPRESS; Integrated Security = true;Connect Timeout=2000;" But it is giving an error as Unrecorganized escape sequence.

[Jeremy Likness]

You need to escape it for the slash, like this: @"Database=QD ;Server=BHUKRK83981D\SQLEXPRESS; Integrated Security = true;Connect Timeout=2000;" Or just double it up: "Database=QD ;Server=BHUKRK83981D\\SQLEXPRESS; Integrated Security = true;Connect Timeout=2000;"

Jeremy Likness Latest Article: Whats in Your Collection? Part 1 of 3: Interfaces Blog: C#er : IMage

[Ashfield]

Basic C# error - you need to escape the \, its nothing wrong with the connection string.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[srikantha_nagaraj]

Thanks it helped a lot.