Data not updating without error I think.

Sorry if this is a dumb question but I am just learning ASP.NET. My database is on a server running SQL Server 2000 and I have used Dreamweaver to build sites. I am trying to convert to ASP.NET.

The problem I am having is that data is not updating when I change it in a GridView, DataList, etc. I have tried including the user name an password in the connection string without success. What did I miss?

connectionString

="Data Source=<ServerName>;Initial Catalog=<DatabaseName>;Integrated Security=True;Uid=sa;Pwd=<Password>;"

This is the string I use in Dreamweaver which works;
Driver={SQL Server};Server=<ServerName>;Database=<DatabaseName>;Uid=sa;Pwd=<Password>;

What are you doing to try and save the data? Please show your code.|||

I got my answer. I had to use SQL Server Authentication. Again I am sorry. I should have known this from my dreamweaver/sql site. My brain must have been fried towards the end of last week.

This brings up another question. Why did I not get some kind of error that the record could not be updated due to whatever?

Have a great one!