Sql error in ASP Page
-
I am getting the following error from an ASP Page: System.Data.SqlClient.SqlException: Login failed for user 'AFFORDABLE02\ASPNET' Now, I added AFFORDABLE02\ASPNET as a user to the database, Public...What am I missing? This is the code that is causing the error: dataSet11.Clear(); sqlDataAdapter1.Fill(dataSet11,"Customer"); Using MSDE here is the connection string: workstation id=AFFORDABLE02;packet size=4096;integrated security=SSPI;data source=AFFORDABLE02;persist security info=False;initial catalog=RentToOwn Thanx in advance! Jude
-
I am getting the following error from an ASP Page: System.Data.SqlClient.SqlException: Login failed for user 'AFFORDABLE02\ASPNET' Now, I added AFFORDABLE02\ASPNET as a user to the database, Public...What am I missing? This is the code that is causing the error: dataSet11.Clear(); sqlDataAdapter1.Fill(dataSet11,"Customer"); Using MSDE here is the connection string: workstation id=AFFORDABLE02;packet size=4096;integrated security=SSPI;data source=AFFORDABLE02;persist security info=False;initial catalog=RentToOwn Thanx in advance! Jude
may be in urs connection string u r missing password.
-
I am getting the following error from an ASP Page: System.Data.SqlClient.SqlException: Login failed for user 'AFFORDABLE02\ASPNET' Now, I added AFFORDABLE02\ASPNET as a user to the database, Public...What am I missing? This is the code that is causing the error: dataSet11.Clear(); sqlDataAdapter1.Fill(dataSet11,"Customer"); Using MSDE here is the connection string: workstation id=AFFORDABLE02;packet size=4096;integrated security=SSPI;data source=AFFORDABLE02;persist security info=False;initial catalog=RentToOwn Thanx in advance! Jude
The solution is : U created the New User named "AFFORDABLE02" but u dont give the permission.. so give permission. So if u work on sqlserver then click on "AFFORDABLE02" user then click on "Permission" button and select the tables for select,delete,insert,update... your work is done... Now Enjoy... :) Dipan Patel.
-
The solution is : U created the New User named "AFFORDABLE02" but u dont give the permission.. so give permission. So if u work on sqlserver then click on "AFFORDABLE02" user then click on "Permission" button and select the tables for select,delete,insert,update... your work is done... Now Enjoy... :) Dipan Patel.
Thanx for the response! I had the Affordable02 as a user but not Affordable02\ASPET...added that one and gave permission! Worked great! While I have some fesh minds...how can you cotrol the size of a data grid?? I have tried setting the height properties, but that doesn't work. The problem is when there are just one or two returns from a select statement, the header and data regions are huge! But when more than 3 row are returned, it is normal size. Thanx in advance Jude