Failure to open rowset?
Posted on 2003-03-21
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.
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?