• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1423
  • Last Modified:

SQL Reporting Services and Informix database

I created a report in Reporting Services (Sql 2000) that queries an Informix database. The dataset selects data from a view (Command type = text) and passes a parameter.  The query works fine in VStudio designer, but when I publish the report to the report server, it fails.  I believe my connection is fine on the report server because when I define the parameter in the report as a certain value, it works.  It's just when the user enters a value that it bombs out.

Here's the error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).

I have noticed that when the user enters a parameter of value 00000189, the report dumps all the zeros and shows only 189.  I don't think this is the problem though because when I enter 189 in designer preview, it works fine too.

Here's my Dataset query:

select * from view where pr_no = ?

Any help you can give is appreciated.

Thanks!
0
JoanHerrick
Asked:
JoanHerrick
  • 3
  • 3
1 Solution
 
nmcdermaidCommented:
Can you try it without the parameter and see if that is causing the error.


i.e.

select * from view where pr_no = 189


or if it's a string

select * from view where pr_no = '189'

0
 
JoanHerrickAuthor Commented:
When I do that, it works fine.  That's what makes me think there's something about the parameter that's a problem.
0
 
nmcdermaidCommented:
Do you know what datatype the field is? is it varchar or integer?

I don't know much about reporting services but perhaps you need to define the correct datatype for your parameter.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
JoanHerrickAuthor Commented:
Yeah, I've tried using both integer and string and neither one seems to work.  
0
 
nmcdermaidCommented:
Are the drivers/driver versions on your development machine and the report machine the same?
0
 
JoanHerrickAuthor Commented:
I'm not exactly sure about this because I haven't had time to research it, but I think you're right.  I awarded the points because I didn't want to leave it hanging plus you were the only one who responded to me.  Thanks!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now