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?

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

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?

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?

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?

Error converting data type varchar to numeric

Hello:
I'm getting the famous "Error converting data type varchar to numeric" error
upon using an If, then statement.
I'm not too familiar with the use of CAST or CONVERT, which I understand
eliminates this sort of error.
How do I use either of those terms in the following SELECT CASE statement:
CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WHEN
'BNSHR' THEN UPR40600.DSCRIPTN
ELSE '0' END As [Payroll Description]
I don't get why SQL thinks I'm trying to do something numeric. All of the
fields in the above statement are string--not numeric. I don't know nuttin'
'bout no numbers!
Thanks!
childofthe1980sPlease don't multi-post. See answer in .programming.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
Hello:
I'm getting the famous "Error converting data type varchar to numeric" error
upon using an If, then statement.
I'm not too familiar with the use of CAST or CONVERT, which I understand
eliminates this sort of error.
How do I use either of those terms in the following SELECT CASE statement:
CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WHEN
'BNSHR' THEN UPR40600.DSCRIPTN
ELSE '0' END As [Payroll Description]
I don't get why SQL thinks I'm trying to do something numeric. All of the
fields in the above statement are string--not numeric. I don't know nuttin'
'bout no numbers!
Thanks!
childofthe1980s|||I have to multi-post, or I don't get an answer.
There is no answer over at the other section either, Tom--just a request to
post data which I cannot post.
This is ridiculous.
childofthe1980s
"Tom Moreau" wrote:
> Please don't multi-post. See answer in .programming.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
> Hello:
> I'm getting the famous "Error converting data type varchar to numeric" error
> upon using an If, then statement.
> I'm not too familiar with the use of CAST or CONVERT, which I understand
> eliminates this sort of error.
> How do I use either of those terms in the following SELECT CASE statement:
> CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
> WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WHEN
> 'BNSHR' THEN UPR40600.DSCRIPTN
> ELSE '0' END As [Payroll Description]
> I don't get why SQL thinks I'm trying to do something numeric. All of the
> fields in the above statement are string--not numeric. I don't know nuttin'
> 'bout no numbers!
> Thanks!
> childofthe1980s
>
>|||Help us help you:
http://www.aspfaq.com/etiquette.asp?id=5006
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:BA8EFDC4-B4C3-4635-931F-90539E6DB06F@.microsoft.com...
I have to multi-post, or I don't get an answer.
There is no answer over at the other section either, Tom--just a request to
post data which I cannot post.
This is ridiculous.
childofthe1980s
"Tom Moreau" wrote:
> Please don't multi-post. See answer in .programming.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
> Hello:
> I'm getting the famous "Error converting data type varchar to numeric"
> error
> upon using an If, then statement.
> I'm not too familiar with the use of CAST or CONVERT, which I understand
> eliminates this sort of error.
> How do I use either of those terms in the following SELECT CASE statement:
> CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
> WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN
> WHEN
> 'BNSHR' THEN UPR40600.DSCRIPTN
> ELSE '0' END As [Payroll Description]
> I don't get why SQL thinks I'm trying to do something numeric. All of the
> fields in the above statement are string--not numeric. I don't know
> nuttin'
> 'bout no numbers!
> Thanks!
> childofthe1980s
>
>|||"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:BA8EFDC4-B4C3-4635-931F-90539E6DB06F@.microsoft.com...
>I have to multi-post, or I don't get an answer.
> There is no answer over at the other section either, Tom--just a request
> to
> post data which I cannot post.
Don't MULTI-post, CROSS-post. (and only then to a select number of groups).
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com