Posted on 2006-05-09
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.
con = new MySQLConnection(new MySQLConnectionString
("hundredacrewood", "WTA", "WTA", "123456").AsString);
"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;