Crystal v10 error using Sage Timberline ODBC driver - Failed to open a rowset.

Trying to upgrade Crystal v8.5 to v10 reports using Sage Timberline Office ODBC driver.  We get the following error message:  Failed to open a rowset. Details: 22007:[TimberlineODBC][TimberlineODBCEngine Driver]Invalid date, time or timestamp value.

What could be causing this??
FrankScaliseAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
frodomanConnect With a Mentor Commented:
Wish I had a less painful answer - good luck.
0
 
frodomanCommented:
I assume the report worked before upgrading to v10?  Did you make sure you're using the latest ODBC driver that is available?

I suspect that there's a date/time field that was being loosely interpreted in v8.5 - maybe has a null value in it - but v10 is much stricter about enforcement of data types.
0
 
FrankScaliseAuthor Commented:
Yes, it works fine in v8.5.  We just upgraded to Sage Timberline Office v9.2.1, so we have the most current ODBC driver.  I'm not having problems upgrading other reports.  This particular report has many formulas using date fields.
0
 
frodomanCommented:
Unfortunately, you're probably going to have to isolate the formula that's causing the error and examine it.  I'd start with any formulas that are converting text -> date (or vice-versa) since the odbc driver may be sending dates in a slightly different format than the previous driver.

If possible, I would create a very small subset of your data to work with.  As I said earlier, there may be a record with a null value in a date field that 8.5 allowed to slip through but 10 isn't allowing.  

You might also try File -> Report Options and check the box for "Convert Database NULL Values to Default".
0
 
FrankScaliseAuthor Commented:
I was afraid you were going to say that...I checked the box for "convert database NULL values to default" but that didn't help.  I think I might have some formulas that convert text to date so I'm going to take a look at those next.

Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.