Hi,

does anybody know how to treat empty date columns (shown as 0 in the
pervasive sql.manager) when accessing them via an Ole DB driver?

I always get an exception when accessing it for example in SSIS or in
my C# code, because 0 is a date out of range.

thanks for your answer!

matt

Matthias wrote:

There are various date "fixer" programs available, such as the free one
on Pervasive's web site in the ComponentZone, or we have our own
product as well that's pretty cheap. They all work the same way --
they change the "0" dates to valid dates, like 1/1/1900 or some other
value.

This is no good for some applications of course, but we can thank
Microsoft for designing such a robust interface (called ODBC) that
simply doesn't allow invalid dates.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***