Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  RS2005 with DB2

Author  Topic  JK_UK Starting Member 1 Post Posted - 2006-08-31 : 07:24:34 Hi all, I'm just getting started with Reporting Services and have a question. I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with: [DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601. I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database. Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database? Many thanks, JK