Format of the initialization string does not conform to specification starting at index 70

Question

3.00/5 (2 votes)

See more:

I have this connection string on c#

C#

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

in web config

C#

<connectionStrings>
   <add name="bongahConnectionString" connectionString="Data Source=./SqlExpress; Initial Catalog=bongah;User Id=x; Password=x"
     providerName="System.Data.SqlClient"/>

How can solve this problem
please help

Posted 10-Jan-14 4:54am

m-e-h-d-h-i

Updated 10-Jan-14 5:21am

v2

Add a Solution

Comments

Ron Beyer 10-Jan-14 11:23am

What version of ASP.NET are you using? 2 or 4?

m-e-h-d-h-i 10-Jan-14 11:26am

4

2 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)

OriginalGriff · Accepted Answer · 2014-01-10T05:01:00

Solution 1

Um.

Data Source=./SqlExpress;Initial Catalog=bongah;User Id=my user id; Password:my password
                                                                         ---^

Are you sure that should be a colon?
Try:

Data Source=./SqlExpress;Initial Catalog=bongah;User Id=my user id; Password=my password

"i had update question"

One thing springs to mind:

C#

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

This reads a string called "ConnectionString" from the web.config file.

HTML

<connectionStrings>
   <add name="bongahConnectionString"
        connectionString="Data Source=./SqlExpress; Initial Catalog=bongah;User Id=x; Password=x"
        providerName="System.Data.SqlClient"/>

This defines a string called "bongahConnectionString" in the web.config file. The two names should match.
Do you also have one called "ConnectionString" that might be confusing the issue?

Posted 10-Jan-14 5:01am

OriginalGriff

Updated 10-Jan-14 5:39am

v2

Comments

Ron Beyer 10-Jan-14 11:03am

+5

Mike Meinz 10-Jan-14 11:08am

+5
And it also looks like there is an extra quote after my password in the add name= value part.

OriginalGriff 10-Jan-14 11:41am

No, the ProviderName is a separate config string attribute:
http://msdn.microsoft.com/en-US/library/htw9h4z3(v=VS.80).aspx

m-e-h-d-h-i 10-Jan-14 11:09am

thank you for your attention but this is syntax error when i did writing codes in codeproject
error still apear

OriginalGriff 10-Jan-14 11:15am

So copy and paste your exact data - don't try and type it in - just replace your username and password with 'X's after you paste it in.

m-e-h-d-h-i 10-Jan-14 11:18am

OriginalGriff 10-Jan-14 11:21am

You forgot something - like text?

m-e-h-d-h-i 10-Jan-14 11:22am

updated

m-e-h-d-h-i 10-Jan-14 11:27am

i had update question

OriginalGriff 10-Jan-14 11:39am

Answer updated

Ron Beyer · Accepted Answer · 2014-01-10T05:31:00

Solution 3

XML

"Data Source=./SqlExpress;

Should be:

XML

"Data Source=.\SqlExpress;

Posted 10-Jan-14 5:31am

Ron Beyer

Comments

m-e-h-d-h-i 10-Jan-14 11:39am

another error
Login failed for user 'x'.

Ron Beyer 10-Jan-14 11:41am

Is it really 'x' or are you just omitting the actual user name? Did you check to see that the SQL server permissions allow that user to log in?

OriginalGriff 10-Jan-14 11:53am

Redacted at my suggestion to prevent him publishing his login details when he pasted the "real" data

Ron Beyer 10-Jan-14 11:59am

Level 1 tech support exists for a reason :) Sometimes the obvious needs to be asked!

OriginalGriff 10-Jan-14 12:19pm

"Is it plugged in?"
"Do you have a power cut? Are the lights working?"
:laugh: