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();
}
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" />
<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]