how to make sql server 2005 connection

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

error as sqlexception.
parameterized query not supplied

Posted 15-Feb-12 20:48pm

vishnumca 2012

Add a Solution

Comments

uspatel 16-Feb-12 2:50am

Where Error occured?
Share code...

Herman<T>.Instance 16-Feb-12 2:52am

please show your code. What SqlException do you get?

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

ProEnggSoft · Answer 1 · 2012-02-15T21:53:00

Solution 2

You may verify with connection strings given at
http://www.connectionstrings.com/[^]

If your problem is solved then you may accept and vote the solution, otherwise please post your queries

PES

Posted 15-Feb-12 21:53pm

ProEnggSoft

Comments

ProEnggSoft 16-Feb-12 4:16am

Thanks for upvote:)

Herman<T>.Instance · Answer 2 · 2012-02-15T20:53:00

Solution 1

One of you parameters has a NULL value. Set this value to DBNull.Value and the parameter is received in the database.

Your title suggests you cannot connect to the server while your last sentence indicates a parameter problem.

Posted 15-Feb-12 20:53pm

Herman<T>.Instance

Jeevitha royapathi · Answer 3 · 2012-02-15T22:38:00

Solution 3

can you post the code where you are getting exception ?

Posted 15-Feb-12 22:38pm

Jeevitha royapathi

AmitKumar89 · Answer 4 · 2012-02-15T23:45:00

Solution 4

You are not providing the required parameters for your stored procedure..

Just have a look on that or else post your query here as a comment..

You will get a appropriate solution.. :)

Posted 15-Feb-12 23:45pm

AmitKumar89