[Mono-list] newbie:help connecting with nysql 5.0

Mon Jul 2 06:29:41 EDT 2007

hello there,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have just got started with mono and having a trouble connecting with Mysql 5.0..It seems it can\'t find the driver needed.I have mysql connector/.net 1.0.9....but can\'t get that working.I read somewhere mono needs 1.0.7 of that connector ,but I can\'t find that version anywhere.Can anyone please tell me which driver to use and a sample code snippet to connect to mysql.Now I am using the sample snippet given in the MONO official site :-****************************************************************************************using MySql.Data.MySqlClient;using MySql.Data;public class Default : Page&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; public virtual void onButtonClick(object sender, EventArgs e)&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; string connectionString =\"Server=localhost;\" + \"Database=test;\" + \"User ID=root;
 \" + \"Password=mysql;\" + \"Pooling=false\";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDbConnection dbcon;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcon = new MySqlConnection(connectionString);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcon.Open();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDbCommand dbcmd = dbcon.CreateCommand();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string sql =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \"SELECT name, age \" + \"FROM table1\";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcmd.CommandText = sql;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDataReader reader = dbcmd.ExecuteReader();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; while(reader.Read()) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string name = (string) reader[\"name\"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string age = (string) reader[\"age\"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.Write(\
 "Name :- \"+name+\"Age :- \"+age);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // clean up&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reader.Close();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reader = null;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcmd.Dispose();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcmd = null;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcon.Close();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbcon = null;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Response.Write(\"Hello\");&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; }*******************************************************************************************and the error I am getting now is :-#################################################################################[Task:File=/home/rupanupal/Projects/NewTest/NewTest/Default.aspx.cs, Line=26, Column=20, Type=Error, Priority=Normal, Description=The type or namespace nam
 e `MySqlConnection\' could not be found. Are you missing a using directive or an assembly reference?(CS0246)]###################################################################################I have the above two references already added.What might be the issue???Please suggest a way.Thanking you all...R. Pal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20070702/452a04dd/attachment.html