In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error:
"ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }"
It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?
Thank you.
Models for Oracle are not currently supported.
BTW, what version of Oracle are you using?
|||Tried it on Oracle 9.2 and 10.1.
Thank you.
|||I have also encountered the identical problem. Has a resolution been provided yet?|||Report Models support Oracle starting from SQL 2005 SP2. Please check SP2 docs for more details.|||I do not see anything for SQL Server 2005 SP2, where can I find more info.|||Alexandre
Where is SQL Server 2005 SP2? We can not find any reference to this release.
|||Will it be supported by SP 2? When can we expect SP 2?
Thanks,
Roman
|||Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver
What is CTP?
Thank you.
|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work onSQL Server 2005 Service Pack 2 CTP (November 2006)?

No comments:
Post a Comment