[es] - C# asp.net i mysql baza

kristian!

Član broj: 8348
Poruke: 150
77.46.178.*

Sajt: www.linkoovi.net

+1 Profil

^{31.10.2008. u 14:31 - pre 188 meseci}

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]}

Odgovor na temu

kristian!

Član broj: 8348
Poruke: 150
77.46.178.*

Sajt: www.linkoovi.net

+1 Profil

Re: C# asp.net i mysql baza

^{31.10.2008. u 23:02 - pre 188 meseci}

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>

Odgovor na temu