Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1298
  • Last Modified:

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??
0
FrankScalise
Asked:
FrankScalise
  • 3
  • 2
1 Solution
 
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
 
frodomanCommented:
Wish I had a less painful answer - good luck.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now