Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Failed to open a rowset Warning/Error

Status
Not open for further replies.

rubinap

Programmer
Aug 26, 2005
6
CA
Hi there

I am working in CR 9.0 and have included subreports in the main report.

Whenever I run the main report and have to give the Login ID & password for the " HiT ODBC / 400 Driver" (DataSource - AS400) I get the following warning/error. If I click the OK button the report is generated.

"Failed to open a rowset.
Details: HY000:{HiT][HiT ODBC/400][SQL/400][ODBS Error][SQL0128] Use of NULL is not valid"

If I run the same report the second/third time - where I do not have to specify the Login ID & password the error does not occur.

How do I get rid of this warning/error msg.

rkp

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top