Solved

hi,

Posted on 2009-04-14
4
284 Views
Last Modified: 2013-12-17
Hi,

I tried accessing a DB using my C# code , but it is throwing SQL Exception 2146232060, now i want to ignore this error and proceed with execution of my program. Can you please provide me with the solution.

Thanks,
Sandy
0
Comment
Question by:sandy3024
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
abel earned 250 total points
ID: 24136647
try something like this:

try 
{
 
    // open your database connection that throws the exception 
    // i.e., your current code
 
}
catch (SQLException e)
{
    // do something, or nothing, with exception here 
}
 
// program continues from here after exception handline

Open in new window

0
 
LVL 39

Expert Comment

by:abel
ID: 24136661
If it is not an SQLException that you are receiving, but something else, then you can add more catch-blocks below the one I showed to have a handler for each exception you need.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24136752
you might want to check your connection strings http://www.connectionstrings.com is a good site

Also according to this, it might be a database setting (thats if you are using sql server)
http://www.dreamincode.net/forums/showtopic32703.htm
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question