Connect to Oracle Database using SQL Server 2000 Reporting Services?

Question

I am trying to create a report in SSRS2000 that will query the ORACLE database and pass one parameter, I get the following error message:

ORA-01036: illegal variable name / number but couldn't find much help elsewhere on the internet with this error code

I was hoping it would be pretty easy to do, does anyone know how to accomplish this task?

0

WACM161 06 nov. '08 at 20:29

2 answers

It turns out that the Parameter1 parameter had to be specified for this, and for dba to have to fix the connection issue!

0

WACM161 06 nov. '08 at 22:00

Mark brady · Accepted Answer · 2008-11-06T22:24:32+0000

You will have to accept some answer to show this question as the "Answer", and you cannot accept it, so it might be.

Guys, I swear I don't troll reputation, I don't even know what is the correct term for this. But if I mark this as Wiki am I wrong? So I did.