August 31, 2006 at 5:29 am
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
September 4, 2006 at 8:00 am
This was removed by the editor as SPAM
September 6, 2006 at 8:54 pm
not 100% but i think report model only works with SQL Server at present, would pay to check. Oracle support is coming. Would pay to check.
Can you import the data with DTS / SSIS into SQL Server.
Martin
September 11, 2006 at 5:17 am
Thanks for the help. I've ended up creating a linked server to UDB in SQL Server 2005. This seems to work fine.
JK
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply