connection string problem

Question

Post reply

connection string problem

erdem

SSC Rookie

Points: 36
More actions
January 25, 2005 at 8:39 am

#66392

Hi Folks,
My SQL Server registration name is TEAM01\ERDEM
I want to connect to this SQL Server databases via .NET. But I always get an error message.
public
static string connectionString = "server=TEAM01\ERDEM database=Northwind;User ID=sa;Password=mlsqlsys;"
How can I rename this SQL Server registration or how can I connect via .NET with this registration name?
Please help

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

PW-201837 SSC-Insane Points: 20805 More actions · Answer 1

Missing a semi-colon between server and database.

erdem SSC Rookie Points: 36 More actions · Answer 2

Thanks for your reply.But When I put a semicolon then I will get the same error message:

-----------------------------------------------------------

public

static string connectionString = "server=TEAM01\xxxx;database=Northwind;User ID=sa;Password=mlsqlsys;";

----------------------------------------------------------

PW-201837 SSC-Insane Points: 20805 More actions · Answer 3

It is generally useful to include the actual text of the error message.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Ninja's_RGR'us

SSC Guru

Points: 294069

January 25, 2005 at 9:46 am

#538988

check out this url

http://www.connectionstrings.com/

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 5

I would try putting the servername like [TEAM01\XXXX]

oh.. and please tell me the password supplied is not the REAL one... IF it is I would probably modify my post and change it....

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Or change it altogether and change the post to XXX just so that noone decides to try to hack your server.

Anthony Sizemore Grasshopper Points: 12 More actions · Answer 7

I don't understand why you can't connect to your server... I connected just fine

FlyingGMan2 SSC Enthusiast Points: 143 More actions · Answer 8

I'm surprised you even compiled. When I try to compile your code, I get an "Unrecognized escape sequence", which is roughly what I expected.

In C#, the "\" in a string literal signifies that the following character should be treated special. For example "\t" means interpret the "t" as a "tab". And "\n" means interpret the "n" as a "newline". To actually include a "\" in your string, you need to tell C# to interpret the "\" as a "\" by included two "\" as follows:

public static string connectionString = "server=TEAM01\\xxxx;database=Northwind;User ID=sa;Password=xxxxxx;";

Alternatively, you can tell C# to interpret the quoted string exactly as written by prefacing with a "@" as follows:

public static string connectionString = @"server=TEAM01\xxxx;database=Northwind;User ID=sa;Password=xxxxxx;";

Step through your code in debug mode and check that the connectionString variable contains exactly what you think it should.

fhanlon SSChampion Points: 13131 More actions · Answer 9

Just a thought in case you were planning to use sa. You may want to reconsider this. The sa user should never be used within an application. A specific id with minimal authority should be used.

btw the connectionstring.com site is a great reference. I didn't know about it.

Francis

erdem SSC Rookie Points: 36 More actions · Answer 10

Thanks for your attentions...

I have solved the problem by using "\\" instead of "\"

I have also modified by connedtion string with all of your guidance as follows:

--------------------------------------------------------------------

public

static string connectionString = "server=TEAM01\\ERDEM;database=ML2005;User ID=erdem_01;Password=SE7377;";

-------------------------------------------------------------------