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