Odd error with Reporting Services and Oracle

I've got a fairly simple report that hits oracle with two parameters set as strings.

When I run the query in the designer, I get

Error Source: System.Data.OracleClient
Error Message: ORA-01858: a non-numeric character was found where a numeric was expected

However, when I run the report in preview everything just works. Same inputs on the parameters.

Any ideas?

What types are your parameters and what is the SQL you are using in your DataSet? I've seen this kind of error passing a parameter that is declared as a string in the report to an oracle parameter that is compared against a Date type in Oracle.

Mike

|||Sorery I meant to post a followup to this. The solution is that SQL RS 2k5 takes a string that happens to be a date and makes it a date without telling.

When it goes into oracle as this "Date" it will go in in the default SQL date format. So you need to match the format mask in the oracle TO_Date function call to the 3 letter month sql format.

Interesting, RS 2K did not do this.

ODBC/SQL M$ EXCEL 97 vs XP

Any ideas appreciated...
Users can export to Excel97 but cannot using ExcelXP. Get
error: "unknown token received from sql server"
Have patched SQL & OfficeXP locally to current M$ levels.
ODBC connects no problem.
I'm a tech, not a programmer, so any ideas really
appreciated.
JimmieDExport from what how? More details needed.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:

quote:

---

>Any ideas appreciated...
>Users can export to Excel97 but cannot using ExcelXP. Get
>error: "unknown token received from sql server"
>Have patched SQL & OfficeXP locally to current M$ levels.
>ODBC connects no problem.
>I'm a tech, not a programmer, so any ideas really
>appreciated.
>JimmieD

---

|||SQL Database using a macro. It appears to download the
info but it looks like right before it displays the data
in EXCELXP, the error appears.
Macro/export functions OK in EXCEL97.
Jim

quote:

---

>--Original Message--
>Export from what how? More details needed.
>-- Mary
>MCW Technologies
>http://www.mcwtech.com
>On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
><anonymous@.discussions.microsoft.com> wrote:
>
Get[QUOTE]
levels.[QUOTE]
>.
>

---

|||I think you're going to have a hard time with this one unless you get
a programmer to help you. If you're using an Excel macro, it's written
in VBA. A programmer can help you step through the code to see where
it's failing.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 08:33:06 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:
[QUOTE]
>SQL Database using a macro. It appears to download the
>info but it looks like right before it displays the data
>in EXCELXP, the error appears.
>Macro/export functions OK in EXCEL97.
>Jim
>Get
>levels.