使用SQL Server 2000 Reporting Services连接到Oracle数据库?

时间:2021-12-05 16:55:58

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必须纠正连接问题!