why if we use sql server name timeout at running stored procedure

Question

0.00/5 (No votes)

See more:

Hi,

I have using connection string as below

HTML

<add name="ConnectionString" connectionstring="User Id = sa; Password = sa; Database = CineVistaDB; Data Source=VEERESH\SQLEXPRESS;" />

If i use Data Source name like this,i'm getting timeout exception while running any Stored procedure.Addition, i know that stored procedure having single T-Sql statement and runs fastly at query runnung window.Please reply to

How to solve this and to change Data source name with ip address of PC,something like Data Source=192.168.0.68

Posted 18-Dec-11 20:00pm

ks ravi

Updated 18-Dec-11 20:09pm

Mehdi Gholam

v2

Add a Solution

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

thatraja · Answer 1 · 2011-12-18T20:32:00

Increase value for Timeout of your SQL Connection & SQL Command

For Connection in Web.Config,

<add key="ConnectionString" value="server=(local); uid=sa; password=sa; database=master;Connection Timeout=30" />

For Command,

public void CreateSqlCommand()
{
   SqlCommand cmd = new SqlCommand();
   cmd.CommandTimeout = 15;
   cmd.CommandType = CommandType.Text;
}

& also take a look at the following page.
Troubleshooting: Timeout expired[^]

Free attachment
DBA’s Quick Guide to Timeouts[^]

devildx2050 · Answer 2 · 2011-12-18T20:22:00

Solution 1

you have to use this code to avoid this problem

using System<pre lang="c#"></pre>.Data.SqlClient;

SqlCommand GstCommand = new SqlCommand();
GstCommand.CommandTimeout = 60;

after adding this code you will not face this problem.

Posted 18-Dec-11 20:22pm

devildx2050

madhuri@mumbai · Answer 3 · 2011-12-18T20:37:00

Solution 3

If your excep not remove using above solution,then
you just verify your query(from stored procedure)execution time.
and optimize your query.
becoz your query take more time than server resp time.
that way timeout error excep occured.

Posted 18-Dec-11 20:37pm

madhuri@mumbai