DataGrid Issue
-
I used the design view to create a datagrid connection, adapter and dataset. I the code view i have ResCasesDataSet2.Clear() ResCasesSqlDataAdapter.Fill(ResCasesDataSet2) However i get an error "Login failed for user ' '" This worked perfectly when i used access database but not with Ms Sql Server. jesa
-
I used the design view to create a datagrid connection, adapter and dataset. I the code view i have ResCasesDataSet2.Clear() ResCasesSqlDataAdapter.Fill(ResCasesDataSet2) However i get an error "Login failed for user ' '" This worked perfectly when i used access database but not with Ms Sql Server. jesa
Your SQL server has a password set. The default is user 'sa' and password 'password' (I think). You need to generate a connection string; to do that you need the password. Talk to whomever is administering your database.
-
Your SQL server has a password set. The default is user 'sa' and password 'password' (I think). You need to generate a connection string; to do that you need the password. Talk to whomever is administering your database.
I have a connection string with a username and password which connects, opens but still throws an error "Login failed for user ' ' " on the code line ResCasesSqlDataAdapter.Fill(ResCasesDataSet2) JESA