The users are going to need the database engines drivers installed onto there machine, also you could use odbc connections to build the connection string. Doing this all you would have to do is publish the odbc driver inside your setup file (You can get this driver from mysql) and then the users would not have to worry about configuring the system as you would do it in code.

Also not that you can also use the free sql express engine, using this would meen that the users would not have to do anything at all as the system can be installed directly from your setup file and the drivers are standard when installing the .net framework 2.0.

Ok glenn would you happen to know how i can use this to display information gotten from a database

basically what i want to do is make this http://www.nextelnoob.com/mp3search.php?textfield=2pac  built into the app so that the users and search ringtones from the app.

So letting the users search the database for a certain values and the app returns anything that it find with that name and posts the results to the user

private void Form1_Load(object sender, System.EventArgs e)
{

    string connectionString = @"Driver={MySQL};SERVER=localhost;DATABASE=NorthwindMySQL;";
    OdbcConnection conn= new OdbcConnection(connectionString);
    conn.Open();
    OdbcDataAdapter da = new OdbcDataAdapter
               ("SELECT ", conn); 
    DataSet ds = new DataSet("Cust");    

    da.Fill(ds, "Customers");
    dataGrid1.DataSource = ds.DefaultViewManager; 
    conn.Close();
}