Skip site navigation (1) Skip section navigation (2)

ODBC Numeric field issue

From: Luciane <Luciane(at)copel(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Numeric field issue
Date: 2010-05-07 14:03:36
Message-ID: 28486416.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi everyone,

I'm trying to access postgres using a ODBC Driver on a Linux system RedHat,
but I'm getting errors with numeric fields, it works only with one numeric
field. Another erro is that it is inserting a NULL record as well.
Below is my ODBC configuration and extracts from the erros on the debug
file. I've tried different versions of ODBC Drivers with no success. If any
one more experient could help me I'll be very happy. Actually I don't know
what to do anymore.

Thanks in advance.

Luciane


------> Odbc Configuration .odbc.ini
[PostG]
#Driver=/usr/lib/libodbcpsql.so.2
#Driver=/produtos/unixODBC-2.2.14/Drivers/Postgre7.1/.libs/libodbcpsql.so
#Driver=/produtos/unixODBC-2.2.10/Drivers/Postgre7.1/.libs/libodbcpsql.so
#Driver=/produtos/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.so
#Driver=/produtos/unixODBC-2.2.13/Drivers/Postgre7.1/.libs/libodbcpsql.so
Driver=/produtos/unixODBC-2.3.0/Drivers/Postgre7.1/.libs/libodbcpsql.so.2
#Driver=/usr/lib/psqlodbcw.so
Description=drive postgres odbc
ServerPort=10.4.3.21:5432
Servername=pgs1dsv
Database=pgs1dsv
sername=c_gco
Password=inicio
ReadOnly=no
Protocol=7.4
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
Debug=1
DebugFile=/tmp/postgII.out
Trace=yes
TraceFile=/tmp/ODBCTrace.log
UseServerSidePrepare=1
DisallowPremature=1
#Parse=1


------> Debug - inserting NULL Record
SQLExecute: copying statement params: trans_status=1, len=66, stmt='INSERT
INTO "teste_carga"("s1", "i1", "n1", "n2") VALUES (?,?,?,?)'
   stmt_with_params = 'INSERT INTO "teste_carga"("s1", "i1", "n1", "n2")
VALUES (NULL,NULL,NULL,NULL)'
      it's NOT a select statement: stmt=140373784
send_query(): conn=140316008, query='INSERT INTO "teste_carga"("s1", "i1",
"n1", "n2") VALUES (NULL,NULL,NULL,NULL)'
send_query: done sending query

------> Debug - Issue on the second numeric field
SQLExecute: copying statement params: trans_status=1, len=66, stmt='INSERT
INTO "teste_carga"("s1", "i1", "n1", "n2") VALUES (?,?,?,?)'
copy_statement_with_params: from(fcType)=1, to(fSqlType)=5
copy_statement_with_params: from(fcType)=1, to(fSqlType)=4
copy_statement_with_params: from(fcType)=1, to(fSqlType)=2
copy_statement_with_params: from(fcType)=1, to(fSqlType)=2
   stmt_with_params = 'INSERT INTO "teste_carga"("s1", "i1", "n1", "n2")
VALUES (00001,0000000001,'0000000001") VALUES
'::numeric,'0000000110Hé'::numeric)'
      it's NOT a select statement: stmt=140373784
send_query(): conn=140316008, query='INSERT INTO "teste_carga"("s1", "i1",
"n1", "n2") VALUES (00001,0000000001,'0000000001") VALUES
'::numeric,'0000000110Hé'::numeric)'
send_query: done sending query
read 1, global_socket_buffersize=4096
send_query: got id = 'Z'
read 62, global_socket_buffersize=4096
send_query: got id = 'E'
send_query: 'E' - ERROR:  invalid byte sequence for encoding "UTF8":
0xe95d08


-- 
View this message in context: http://old.nabble.com/ODBC-Numeric-field-issue-tp28486416p28486416.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-05-07 20:41:38
Subject: Re: ODBC Driver for Windows 64bit
Previous:From: Stefan WalterDate: 2010-05-06 12:19:12
Subject: Re: ODBC Driver for Windows 64bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group