Wednesday, March 21, 2012

Error creating Report Model based upon Oracle Database

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 on
SQL Server 2005 Service Pack 2 CTP (November 2006)?
|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?sql

No comments:

Post a Comment