Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'

From: John DeSoi <desoi(at)pgedit(dot)com>
To: mg <postgres(at)ballistech(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'
Date: 2005-03-28 20:39:35
Message-ID: 7F1BE9B8-9FC9-11D9-A2EC-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


On Mar 28, 2005, at 10:57 AM, mg wrote:

> I've searched http://search.postgresql.org/ and Google on this error
> to no
> avail. I suspect this problem relates to the integer / single quote
> issue
> referenced in previous posts. It may also relate to the domain I
> created,
> but I'm not sure how to proceed.

What happens if you just define id as int4 rather than using the
domain? I'm not really familiar with ACCESS/ODBC, but I'm wondering if
it really knows anything about domains.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Goei 2005-03-28 22:06:00 Re: MS Access/ODBC 'ERROR: invalid input syntax fo
Previous Message mg 2005-03-28 15:57:19 MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'