?
Solved

MySQLDriverCS

Posted on 2006-05-09
4
Medium Priority
?
965 Views
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 com.open().  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.

thanks
     Dave.


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

                con.Open();

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

                MySQLCommand cmd = new MySQLCommand(sql, con);
                cmd.ExecuteNonQuery();
                con.Close();
             }
            catch (MySQLDriverCS.MySQLException ex)
            {
                RTB_SQL.Text = ex.Message.ToString()+ RTB_SQL.Text;
            }
0
Comment
Question by:drmiller32
  • 3
4 Comments
 
LVL 16

Expert Comment

by:ellandrd
ID: 16647494
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?
0
 
LVL 16

Accepted Solution

by:
ellandrd earned 740 total points
ID: 16647518
0
 

Author Comment

by:drmiller32
ID: 16647699
Thnaks for the help.  Solved my problem.
0
 
LVL 16

Expert Comment

by:ellandrd
ID: 16647705
;-)
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month16 days, 14 hours left to enroll

864 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