accessing empty date columns via ole db

Matthias wrote:

> 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

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@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***