(odbc) multiple step ole db generated error - date/timestamp column

From: zach cruise <zachc1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: (odbc) multiple step ole db generated error - date/timestamp column
Date: 2009-03-21 05:39:52
Message-ID: bcdac0e80903202239s4b01d95fk23ba930665ef90cf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

when importing from oracle 10g, i get "multiple step ole db generated
error". i narrowed this down to a date/timestamp column - actually to
about 100 rows within that column, all = '01-JAN-01' (never null).

there is another date/timestamp column that gets imported error-free,
and other tables also get imported fine, so i am stumped?

query log not very helpful. using 8.1 with navicat.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lew 2009-03-21 06:34:42 Re: I don't want to back up index files
Previous Message Amitabh Kant 2009-03-21 04:49:58 Re: PostgreSQL versus MySQL for GPS Data