UDL File not found exception on Application Start

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have written the following code to implement common connection string so that all the forms use the connection string provided in Login Form of my application.The application works fine on my machine but when I run my application on any other machine I get the error "Connection to the server could not be established" ie it enters the catch block. even when the UDL file is available on the machine.Can anyone help me to rectify this. Thanks

C#

public void FrmLogin_Load(object sender, EventArgs e)
        {


            btncancel.CausesValidation = false;


            try
            {

                string FileName = "Intellect_LeadMt.udl";
                if (!File.Exists(FileName))
                {
                    MessageBox.Show(FileName + " File is not available in current folder!");
                    //return;
                    this.Close();
                }

                string[] str = File.ReadAllLines(FileName);
                con = new OleDbConnection(str[2]);
                con.Open();

                add = new AddModify_Lead(this);
                foll = new Follow_Lead(this);
                rem = new Reminder_Lead(this);
                ContctAdd = new AddContact(this);
                UtilityMaster = new UtilityMasters(this);
                LeadManagerForm = new LeadManager(this);
                Register = new FrmRegistration(this);
                Mainform = new Form1(this);
                Ld = new LoginDetails(this);
                Ul = new UserLog(this);
                Mc = new Modify_Client(this);
            }
            catch
            {
                MessageBox.Show("Connection to Database currently is unavailable!\n Please Check udl and start application once again.\n Sorry For the inconvenience", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
                Application.Exit();

            }

          }

Posted 2-Dec-14 20:12pm

vivek murli

Updated 2-Dec-14 21:58pm

Add a Solution

1 solution

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)

DamithSL · Answer 1 · 2014-12-02T20:30:00

You are swallowing exception in your method. if you need to find error details you may need to show full error as message or write the full error to a textile. for example:

C#

try
{
  // your code 

}catch(Exception ex)
{
  //1. show full error message 
  //MessageBox.Show(ex.ToString());
  //or
  //2. show StackTrace
  //MessageBox.Show(Ex.StackTrace);
  //or
  // log the errors to a file..
}

then you able to find the detailed error and it will help you to find solution.