[ kristian! @ 31.10.2008. 14:31 ] @
Izvinjavam se u napred ako ova tema postoji.

pokusavam da se nakacim na mysql bazu:

Code:

 protected void Page_Load(object sender, EventArgs e)
    {
        string dbConnStr = ConfigurationManager.ConnectionStrings["aspxConnectionString"].ConnectionString.ToString();
        string query = "SELECT * FROM user";
        SqlConnection dbConn = new SqlConnection(dbConnStr);
        SqlCommand comm = new SqlCommand(query, dbConn);

        dbConn.Open();
        comm.CommandText = query;
        SqlDataReader reader = comm.ExecuteReader();

        while (reader.Read())
        {
            Label1.Text = reader["username"].ToString();

        }
        reader.Close();
    }

i web.config
Code:

<add name="aspxConnectionString" connectionString="server=localhost;user id=root;database=aspx" providerName="MySql.Data.MySqlClient" />



dbConn.Open(); ovde dobijem upozorenje:

Login failed for user 'root'. The user is not associated with a trusted SQL Server connection.


kroz navicat sam podesio da root ima sva ovlascenja nad bazom.

u cemu je problem?

[Ovu poruku je menjao kristian! dana 31.10.2008. u 22:46 GMT+1]
[ kristian! @ 31.10.2008. 23:02 ] @
ok resio problem:


Code:

using MySql.Data.MySqlClient;



protected void Page_Load(object sender, EventArgs e)
    {
        
        string dbConnStr = ConfigurationManager.ConnectionStrings["aspxConnectionString"].ConnectionString.ToString();
        string query = "SELECT * FROM user";
        MySqlConnection dbConn = new MySqlConnection(dbConnStr);
        MySqlCommand comm = new MySqlCommand(query, dbConn);
       
            dbConn.Open();

            comm.CommandText = query;
            MySqlDataReader reader = comm.ExecuteReader();
            while (reader.Read())
            {
                   Label1.Text = reader["username"].ToString();
            }
            reader.Close();
        

        

    }


web.config
Code:

<compilation debug="true">
      <assemblies>
    <add assembly="MySql.Data, Version=5.0.9.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
      </assemblies>
    </compilation>