Re: -2147217842 Operation was canceled - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: -2147217842 Operation was canceled
Date
Msg-id EKEJJICOHDIEMGPNIFIJEEIKFKAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: -2147217842 Operation was canceled  ("Ryan C. Bonham" <Ryan@srfarms.com>)
List pgsql-odbc
> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan@srfarms.com]
>
> Ok,
> On exploring this issue some more here is what have. The field I
> was having
> this problem with was a date field, so I believe what was happening was it
> was trying to insert a value of '' into a date field, and
> actually returning
> a "Bad date external representation."  so I added the following
> commands to
> the form.
> If txtdate3ties.Text = Empty Then
>     DataEnvironment1.rscmdRecentHeats.Fields("date3ties").Value = Null
> End If
>
> Now is actually does make the change to that field, but it still fails on
> the move, and spits out the error.. Weird..

Please start the postmaster with -d option and see what queries are
issued at server side in the log.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Jim Dickenson
Date:
Subject: Mac OS X problem
Next
From: Denis Gasparin
Date:
Subject: Re: Writing BLOBS to pgsql via ODBC using VB