I am trying to create a report in SSRS2000 that will query an ORACLE database and pass one parameter, I am getting the following error message:
我试图在SSRS2000中创建一个报告,它将查询ORACLE数据库并传递一个参数,我收到以下错误消息:
ORA-01036: illegal variable name/number But have been unable to find much help elsewhere on the web with this error code
ORA-01036:非法变量名称/编号但是在此处错误代码无法在网络上的其他地方找到太多帮助
I was hoping that this would be fairly simple to do, does anyone have any idea how to accomplish this task?
我希望这样做相当简单,有没有人知道如何完成这项任务?
2 个解决方案
#1
0
You'll have to accept some Answer in order to show this question as "Answered" and you can't accept your own, so it might as well be this one.
你必须接受一些答案才能将这个问题显示为“已回答”并且你不能接受自己的问题,所以它也可能是这个问题。
Guys, I Swear I'm not trolling for rep, I don't even know what the proper term for that is. But if I mark it as Wiki, I won't right? So I did.
伙计们,我发誓我不会为代表拖钓,我甚至不知道这个问题的正确用语是什么。但如果我把它标记为Wiki,我会不对的?所以我做了。
#2
0
It turns out that the parameter had to be named Parameter1 for this to work, and that the dba had to correct a connection issue!
事实证明,参数必须命名为Parameter1才能使用,并且dba必须纠正连接问题!
#1
0
You'll have to accept some Answer in order to show this question as "Answered" and you can't accept your own, so it might as well be this one.
你必须接受一些答案才能将这个问题显示为“已回答”并且你不能接受自己的问题,所以它也可能是这个问题。
Guys, I Swear I'm not trolling for rep, I don't even know what the proper term for that is. But if I mark it as Wiki, I won't right? So I did.
伙计们,我发誓我不会为代表拖钓,我甚至不知道这个问题的正确用语是什么。但如果我把它标记为Wiki,我会不对的?所以我做了。
#2
0
It turns out that the parameter had to be named Parameter1 for this to work, and that the dba had to correct a connection issue!
事实证明,参数必须命名为Parameter1才能使用,并且dba必须纠正连接问题!