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