Posted on 2006-05-09
Last Modified: 2008-02-26
I have written a program that seems to work properly on my office computer I connect to the data base Insert, Delete and update without a problem.  But when I installed on lab computers it appears that the connectins fails.  I kept getting errors saying that there was an excption error and the program needed to close.  I tride updateing all the 1.1 and 2.0 net.Frame componets.  No success.  I then installed visual studio 2005 on the lab computer and I get an error at the command line  I do not know what exception is beeing thrown. But I can't step beyond that point.  My two office computers work great.  Only when I install on a lab computer.
I'm assuming this may be a driver issue but not forsure im using MySQLDriverCS 3.51.  The code is listed below.


                MySQLConnection con;
                con = new MySQLConnection(new MySQLConnectionString
                          ("hundredacrewood", "WTA", "WTA", "123456").AsString);


                sql =
                    "INSERT INTO main_userslogedin ("
                        + "UAN, "
                        + "ULN, "
                        + "RD, "
                        + "CN, "
                        + "ULAT) "
                        + "Values ('" + UAN + "', '" + UN+ "', '" + RN + "', '"
                        + WS  + "', '" + ULAT + "');";

                MySQLCommand cmd = new MySQLCommand(sql, con);
            catch (MySQLDriverCS.MySQLException ex)
                RTB_SQL.Text = ex.Message.ToString()+ RTB_SQL.Text;
Question by:drmiller32
    LVL 16

    Expert Comment

    what language are you programming in?

    is may not have anything to do with MYSQL.  I suggest try getting a simple connection working first to take MYSQl out of the equation - at least that way, we know MYSQL isnt the problem.

    There might be a number of reason to why you get these errors.  These can include access rights to MYSQL on lab machine... god only knows.

    can you provide more info to help us solve your problem?
    LVL 16

    Accepted Solution


    Author Comment

    Thnaks for the help.  Solved my problem.
    LVL 16

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now