Database Connection String Problem

Question

4.50/5 (2 votes)

See more:

Hi I am having trouble with allowing others to connect to my server. I am running server 2008, I have changed all the settings to allow incoming connections and followed a few guides but all seem to have failed miserable.

This connections string works fine to connect to the db locally:

SqlConnection conn = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Food;Integrated Security=SSPI;");

however when I try and substitute it for a ip based connection string:

SqlConnection conn = new SqlConnection("Data Source= ipaddy,1433;Network Library=DBMSSOCN;Initial Catalog=food;");

it completly crashes my program and it won't load at all.

If someone could help would be much appreciated cheers in advance

Posted 16-Jun-11 3:05am

DanHodgson88

Add a Solution

Comments

DanHodgson88 6-Mar-13 9:50am

Can I ask why everyone has now started answering this? It was a year and a half ago.....

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

recoverinfotech · Answer 1 · 2013-03-05T13:35:00

you have 2 error

1) use user name of your pc b4 the servername

error

SQL

Data Source=.\\SQLExpress;Initial

ans

SQL

Data Source=PC Username\\SQLExpress;Initial

cos (.) only work with Sql 2000

2) use @ b4 connection string

C#

SqlConnection conn = new SqlConnection(@"Data Source=.\\SQLExpress;Initial Catalog=Food;Integrated Security=SSPI;");

And the Final Connection string will

C#

SqlConnection conn = new SqlConnection(@"Data Source=PC Username\\SQLExpress;Initial Catalog=Food;Integrated Security=SSPI;");

amit28august · Answer 2 · 2011-06-16T03:08:00

Solution 1

check for the username and password for the server system sql.

Posted 16-Jun-11 3:08am

amit28august

karan joshua · Answer 3 · 2011-06-16T03:11:00

Solution 2

try to store connection string in web.config file..

Posted 16-Jun-11 3:11am

karan joshua

MalwareTrojan · Answer 4 · 2013-03-05T17:52:00

Solution 4

you should also give username and password of your database in the string.

Posted 5-Mar-13 17:52pm

MalwareTrojan

Aarti Meswania · Answer 5 · 2013-03-05T18:32:00

simple way is

drag a datagridview on form
now, see arrow button at top right,
click add new datasource

now in a new window new datasource -> then give name of sql server, username - pwd select database & hit TestConnection button if successful then click ok

in window u will get your connection string copy-paste and use it in code
now u can remove datagridview from form

Happy Coding!
:)

Virendra Maurya · Answer 6 · 2013-03-06T00:06:00

Solution 6

C#

SqlConnection conn = new SqlConnection(@"Data Source=DATA SERVER ADDRESS ;Initial Catalog='NAME DATA BASE';USE='DATA BASE USER ID';PWD='DATA BSEA PASSWORD'");

Posted 6-Mar-13 0:06am

Virendra Maurya

Updated 6-Mar-13 0:17am

v2

Motamas · Answer 7 · 2013-03-06T02:13:00

Solution 7

Create a text file (connection.txt) rename it to connection.udl. Open it set and up the connection. Close it and open it again with notepad. The Connection string will be there.

Posted 6-Mar-13 2:13am

Motamas