It finally works now, but I had to re-develop the report from scratch, using the same queries and controls...

But I still do not understand what was the problem at the...

Yes, I'm sending the credentials :

ReportingService rs = new ReportingService();

...

by putting the sp between try/catch resolves the problem, and i'm able to rollback the transaction started in the sp

thanks...

Matt Miller (3/21/2008)

---

patrick h (3/21/2008)

---

Matt,

Yes I think so, but even if a put a commit or rollback right after the exec, the message remains. I'm trying to figure why...

Still, when...

Matt,

Yes I think so, but even if a put a commit or rollback right after the exec, the message remains. I'm trying to figure why...

Still, when I execute the sp...

Hi

Here is how I would do.

the expression : dateadd(dd, 0, datediff(dd, 0, <Colum in DATETIME Format)) actually returns the the date part of the column with the time set to...

Thanks, but i've found the solution : actually my firewall settings prevented any actual connection to a remote database.

I changed them and now it's ok.