Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Failure to open rowset?

Posted on 2003-03-21
6
Medium Priority
?
413 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
  • 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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

581 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