Connect to Oracle Database using SQL Server 2000 Reporting Services?
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
source
to share
2 answers
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.
0
Mark brady
source
to share
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
source
to share