client encoding mismatch

From: prashanth k p <konkodi210(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: client encoding mismatch
Date: 2009-05-11 10:02:50
Message-ID: 69d075ef0905110302p5907b06fv23fa66884fa694af@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi All,
I am running Postgre server in Windows platform. I have
installed psqlodbc-08.03.0400 odbc driver and libiodbc-3.52.6 driver for
connecting Postgre database form Red Hat Linux platform.

To test the application I have written a small Java program. When I execute
the program I get below mentioned error

SQLException: SQLState(22003) vendor code(214)
java.sql.SQLException: [unixODBC]client encoding mismatch
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)

Java Program:
-----------------------------------------------------
DriverManager.setLogWriter(new PrintWriter(System.out));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection ( "jdbc:odbc:postgres",
"postgres", "demopswd");

odbc.ini
-----------------------------------------------
[ODBC Data Sources]
postgres = PostgreSQL Test

[postgres]
Driver=/usr/lib/psqlodbc.so
Description=PostgreSQL DSN
DSN=postgres
Servername=192.43.53.64
Username=postgres
Database=postgres
ReadOnly=No
Servertype=postgres
Port=5432
FetchBufferSize=99
ReadOnly=no
Trace=1
TraceFile=/home/oralsh/odbc.trace
Debug=1
DebugFile=/home/oralsh/odbc.debug
CommLog=1

[Default]
Driver = /usr/lib/libodbc.so

odbcinst.ini
-----------------------------------
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
I even tried to change encoding by running "alter user postgres SET
client_encoding to UNICODE;" but still I get the same error

I dont know what is the mistake I have done. I request you please help me to
resolve the issue

--
regards
Prashantha K P

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message prashanth k p 2009-05-11 11:57:52 Re: client encoding mismatch
Previous Message Zahid Khan 2009-05-11 09:33:55 psqlodbc driver issue