Still my issues is not solve connection string issues

Question

0.00/5 (No votes)

See more:

Hi
i am using visual studio 2008 and sl server 2008 web application.

in web.config i have given connection string

C#

<connectionStrings>
		<add name="ApplicationServices" connectionString="data source= midas Host;Integrated Security=SSPI;intial catalog=kandivalideal;User Instance=true" providerName="System.Data.SqlClient"/>
	</connectionStrings>

and then i am trying to call the connection string on default page

SqlConnection cnn = new SqlConnection();
        cnn.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
        cnn.Open(); 
        SqlCommand cmd = new SqlCommand("select mobileno, password from register where mobileno='" + txtmobile.Text + "'and password='" + txtpassword.Text + "'", cnn);
        cmd.Connection = cnn;
        SqlDataReader dr = cmd.ExecuteReader();

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

can any one tell me what is the issues

Posted 19-Dec-11 17:50pm

aayu

Updated 19-Dec-11 19:50pm

v5

Add a Solution

Comments

thatraja 20-Dec-11 0:15am

Use parametrized query to avoid Sql injection

AmitGajjar 20-Dec-11 0:41am

you have used wrong Spelling for "Initial Catalog"

thanks
-amit

aayu 20-Dec-11 0:50am

i have done the changes still it is giving me error

Shobana16 20-Dec-11 2:00am

Did u try solution5?

aayu 20-Dec-11 2:00am

yes shobana i did

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

Shobana16 · Answer 1 · 2011-12-19T20:09:00

Try this,
C#

C#

SqlConnection cnn = new SqlConnection();
        string sqlcon = System.Configuration.ConfigurationManager.AppSettings["connString"];
        cnn = new SqlConnection(sqlcon);
        cnn.Open();
        SqlCommand cmd = new SqlCommand("select mobileno, password from register where mobileno='" + txtmobile.Text + "'and password='" + txtpassword.Text + "'", cnn);
        cmd.Connection = cnn;
        SqlDataReader dr = cmd.ExecuteReader();

web.config

HTML

<appsettings>
<add key="connString" value="server=midas Host;database=kandivalideal;" />
</appsettings>

m@dhu · Answer 2 · 2011-12-19T17:53:00

Solution 1

I think you missed the namespace System.Configuration[^]

Posted 19-Dec-11 17:53pm

m@dhu

koolprasad2003 · Answer 3 · 2011-12-19T18:00:00

Solution 2

Add a reference to System.Configuration by clicking Project -> Add Reference... and searching through the .NET components for System.Configuration
add namespace System.Configuration.

Posted 19-Dec-11 18:00pm

koolprasad2003

Shobana16 · Answer 4 · 2011-12-19T18:09:00

Solution 3

Try to put ,,

C#

cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;

Posted 19-Dec-11 18:09pm

Shobana16

Updated 19-Dec-11 18:13pm

v2

Comments

aayu 20-Dec-11 0:17am

It is giving error Keyword not supported: 'intial catalog'.

Shobana16 20-Dec-11 0:58am

Can you try this , by giving connection string in appsettings?

Sarvesh Kumar Gupta · Answer 5 · 2011-12-19T18:39:00

add namespace System.Configuration.
===================
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"]);

cnn.Open();

======================

in web.config

<connectionstrings>
<add name="ApplicationServices" connectionstring="data source= midas Host;Integrated Security=SSPI;initial catalog=kandivalideal;User Instance=true" providername="System.Data.SqlClient">

====================

You have written "intial catalog" place of "initial catalog".
initial catalog is a right word.

Shobana16 · Answer 6 · 2011-12-19T19:00:00

Solution 5

Try this..

C#

<add name="ApplicationServices" connectionstring="server= midas Host;databse=kandivalideal;" providername="System.Data.SqlClient" />

Posted 19-Dec-11 19:00pm

Shobana16

Anele Ngqandu · Answer 7 · 2011-12-20T11:32:00

Solution 7

Try to run visual studio and sql server as administrator

Posted 20-Dec-11 11:32am

Anele Ngqandu

Sachin Suryawanshi · Answer 8 · 2011-12-21T02:10:00

Solution 8

Please check the spelling of intial It must be Initial.

I hope this will work..

Posted 21-Dec-11 2:10am

Sachin Suryawanshi

srinivas vadepally · Answer 9 · 2011-12-21T02:34:00

Solution 9

hi aayu,
Named Pipes Provider, error: 40 --Could not open a connection to SQL Server Microsoft SQL Server[^]

Posted 21-Dec-11 2:34am

srinivas vadepally