system.transaction problem

[hspc]

Hi
Connection! connection string does not have the username and password and also does not specify a trusted connection (windows authentication)
try to change it to:

using(  SqlConnection connection1 = new SqlConnection("Data Source = localhost;Initial Catalog = pubs;Integrated Security=True;"))

I wish this solves the problem ,, but I'm still confused about it becasue if this was the problem the error message should be (login failed for user XXX......)
Anyway..try it and tell us...