Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Reporting Services by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee; ISBN: 9780470242018
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 9th, 2009, 03:34 AM
Registered User
 
Join Date: Jul 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default report dump

I've got a problem. I've made a report. It works on all pc's except one.
Sometimes the report works, sometimes not.
It gives the message:
cannot read the next data row for the data set _____
ERROR [58005] [IBM] [DB2.NET] SQL0902 an unexpected error has occurred
 
Old July 9th, 2009, 05:05 AM
Wrox Author
Points: 183, Level: 3
Points: 183, Level: 3 Points: 183, Level: 3 Points: 183, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It looks like the error is being reported by your DB2 data provider or driver. When you say that the report doesn't work on one particular PC, are you previewing the report on that machine in the report designer or through the Report Manager web interface? Please provide more details and explain how you have deployed and how you are viewing this report. Most likely this is a problem with the data provider configuration or database connectivity.

I suggest that you also post this to the Reporting Services or Data Connectivity forums on MSDN at: http://social.msdn.microsoft.com/For...gory/sqlserver
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access
 
Old July 9th, 2009, 07:18 AM
Registered User
 
Join Date: Jul 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default error continued

I use the dot net driver for ibm db2.
The error occurs in the report designer preview window.
I do a import of the report on the different pc's.
i'v e tried to correct it with modifiying the time-out of db2.
(it was a suggestion i've found on the net) but it didn't help
 
Old August 13th, 2009, 02:49 AM
Registered User
 
Join Date: Jul 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default solution

according to a colleque of mine the problem is the db2 driver. when we change the language of the computer it works fine. (probably a conversion error from dutch formats to English formats)

solution:
start -> configuration -> country propeties -> advanced -> unicode language = English (US)




Similar Threads
Thread Thread Starter Forum Replies Last Post
Mini dump file Baby_programmer BOOK: Professional Team Foundation Server ISBN: 0-471-91930-6 0 June 25th, 2008 03:37 PM
MS-Access Dump ramuis78 Access VBA 2 January 25th, 2007 02:55 PM
MySql data dump itHighway Beginning PHP 2 May 29th, 2006 01:15 PM
MySql data dump itHighway Classic ASP Databases 0 May 28th, 2006 06:12 PM
dump info sam SQL Server ASP 0 January 22nd, 2004 04:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.