Home Forums SQL Server 2005 T-SQL (SS2K5) Failed to open a rowset - occurs for some users and not others when running the query via a report in Crystal RE: Failed to open a rowset - occurs for some users and not others when running the query via a report in Crystal

  • Try to use this:

    convert(datetime, convert(varchar, createddate, 103), 103)

    The problem is in the fact that your conversion is using default connection language for outer conversion and if this language happens to have months and days switched, you can get datetime overflows.

    HTH

    Piotr

    ...and your only reply is slàinte mhath