Get Error when run DataReport 1

[JohnBates]

Here is the situation:
Using VB 6 and SQL Server 7

This DataReport program issues error "Failed getting RowSet from current data source." But we only get this error when we run the app on a certain PC. When the same user logs onto another PC, he is able to run this app with no problems.

** Interestingly, this app also displays data (from the same table as the DataReport uses) via a DataGrid..... this ALWAYS works properly, for all users, all PCs.

So.... just what would cause the "Failed getting RowSet from current data source" error only on the DataReport and only on certain PCs? **

Thanks for any help. Regards, John

 

[JimPaum]

John,

I read your December 2000 post on "Failed getting rowset(s) from the current data source." Did you ever get it resolved? If so, what is the solution? I too have a similar problem when I try to display reports on some, but not all, machines. I have found I can get the same error on my development machine by running my program back-to-back inside the ID. The program creates a temporary database with multiple tables; QA's data from another database; writes messages to these tables about problems with the data being QA'd; then displays the problems in reports (one for each temporary table). In the current program structure, I can prevent the user (and me) from running the program back-to-back, but I am baffled when I get the error on the first run of the program.

Jim Paumier