(odbc) multiple step ole db generated error - date/timestamp column
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.
zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB link of some sort?
Operating system and version? Oracle version?
i get "multiple step ole db generated
error".
From what program ? Where?
--
Craig Ringer
On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB link of some sort?
odbc (see email) specifically Microsoft OLE DB Provider for Oracle
Operating system and version? Oracle version?
windows 2k3
oracle 10g (see email)
postgresql 8.1 (see email)
i get "multiple step ole db generated
error".From what program ? Where?
navicat (see email)
again, i narrowed this down to a date/timestamp column that gets
imported ok if imported as varchar. there is another date/timestamp
column that gets imported error-free, and other tables also get
imported ok. based on my narrowing-down, it appears less likely error
is at os/odbc/postgresql/oracle level but more likely at
database/table/column/row level (esp since all problem rows =
'01-JAN-01' (never null) but that could be a false-alarm).
ok i brought it in as varchar and cast as date.
Show quoted text
On Sun, Mar 22, 2009 at 12:27 PM, zach cruise <zachc1980@gmail.com> wrote:
On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer
<craig@postnewspapers.com.au> wrote:zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB link of some sort?
odbc (see email) specifically Microsoft OLE DB Provider for Oracle
Operating system and version? Oracle version?
windows 2k3
oracle 10g (see email)
postgresql 8.1 (see email)i get "multiple step ole db generated
error".From what program ? Where?
navicat (see email)
again, i narrowed this down to a date/timestamp column that gets
imported ok if imported as varchar. there is another date/timestamp
column that gets imported error-free, and other tables also get
imported ok. based on my narrowing-down, it appears less likely error
is at os/odbc/postgresql/oracle level but more likely at
database/table/column/row level (esp since all problem rows =
'01-JAN-01' (never null) but that could be a false-alarm).