?
Solved

Failure to open rowset?

Posted on 2003-03-21
6
Medium Priority
?
410 Views
Last Modified: 2012-06-27
Okay, here's the situation:

If I try to open an already created report that uses an Informix database, it will give me the following error:

Failure to open rowset  (press ok)

Failed to open a rowset.  
Details: HY000:[Informix][Informix ODBC Driver][Informix]Syntax disallowed in this database server.
(press ok)

However, if I create a new report from the same database and THEN open the already created report, it opens without any problems.  None of the other type of databases I use have given me this error.  And it seems to be all of the already created reports with the Informix that gives me this error.  Oh, and I've worked in both a WindowsXP & Windows2000 environment; It happens in both.

How do I fix this?
0
Comment
Question by:CynderWolve
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 750 total points
ID: 8183925
Sounds like the database is not open.

Try this
Open the report
Click DATABASE --> LOGON SERVER
logon the server
Try to preview the report

mlmcc
0
 

Author Comment

by:CynderWolve
ID: 8183976
It does say that I am logged onto the server that this database is stored on.  It appears to be at the same place where the other databases are stored - I'll ask the person who works with the connections more when she gets back in.  But until then - any other suggestions?
0
 

Author Comment

by:CynderWolve
ID: 8184001
It does say that I am logged onto the server that this database is stored on.  It appears to be at the same place where the other databases are stored - I'll ask the person who works with the connections more when she gets back in.  But until then - any other suggestions?
0
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 

Author Comment

by:CynderWolve
ID: 8184010
Sorry for the double post.  I just followed your thinking and found the 'refresh' for the connection, and that seems to have worked!  Thank you :)
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8184420
Glad to help.

To avoid double posts use the RELOAD QUESTION under your name in the left column rather than refresh.

mlmcc
0
 

Author Comment

by:CynderWolve
ID: 8204790
Ah.  Thanks for the tip. :)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question