Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1439
  • 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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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