Re: psqlODBC 'ERROR: invalid input syntax for integer: "
От | Greg Campbell |
---|---|
Тема | Re: psqlODBC 'ERROR: invalid input syntax for integer: " |
Дата | |
Msg-id | 424B007D.2030001@us.michelin.com обсуждение исходный текст |
Ответ на | Re: psqlODBC 'ERROR: invalid input syntax for integer: " (Michael Goei <postgres@ballistech.com>) |
Список | pgsql-odbc |
I tried to use domains once, and Access/ODBC completely did not understand the data type, so I changed to a primitive data type (int4) and things worked. I did not have time to debug whether the issue was Access or the ODBC driver implementation or the ODBC standard. Michael Goei wrote: >I'm attempting to link the postgres table with MS Access, via the ODBC >driver. After the link process, when I open the linked table from within MS >Access, an error is generated. When I inspect the connection log, I find >the following entry (SQL auto-generated by MS Access/ODBC): > >conn=122491600, query='SELECT >"id","unid","rid","trxtype","bilb","entjobcustid" FROM "public"."trx" >WHERE "id" = 'A' OR "id" = 'Ø' OR "id" = 'Ù' OR "id" = 'Ú' OR "id" = >'Û' OR "id" = 'Ü' OR "id" = 'Ý' OR "id" = 'Þ' OR "id" = 'ß' OR "id" = >'à'' >ERROR from backend during send_query: 'ERROR: invalid input syntax for >integer: "A"' >STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while >executing the query' > >I believe that MS Access (or ODBC) is misinterpreting the id field. It's >actually defined as a custom domain of type int4, but because of the >misinterpretation, MS Access is trying to select a page full of records >using erroneous SQL (it assumes that the "id" field is character instead of >int4). > >When I create a test table and specify that the attribute "id" is of type >int4 (instead of a custom int4 datatype), then MS Access/ODBC can open the >table from it's GUI properly. So, I've traced the problem down to a >misinterpretation of the custom domain. > >I'm looking for a solution that will allow MS Access/ODBC to recognize the >int4 domain and open the table properly. > >Thanks, > >mg > >-----Original Message----- >From: Peter Eisentraut [mailto:peter_e@gmx.net] >Sent: Wednesday, March 30, 2005 10:08 AM >To: Michael Goei >Cc: 'pgsql-odbc@postgresql.org' >Subject: Re: [ODBC] psqlODBC 'ERROR: invalid input syntax for integer: >"A"' > > >Michael Goei wrote: > > >>Can someone please help me solve this problem please? >> >> > >Well, the column is defined as an integer and you are trying to put >non-numeric characters in it. Why is that? > > >
Вложения
В списке pgsql-odbc по дате отправления: