client encoding mismatch

am 11.05.2009 12:02:50 von prashanth k p

--0016e644cd9abc983e0469a01418
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--0016e644cd9abc983e0469a01418
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,

I am running Postgre server in Windows platform.=
I have installed=A0psqlodbc-08.03.0400 odbc driver and=A0libiodbc-3.52.6 d=
river 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 =A0below mentioned error

div>

SQLException: SQLState(22003) vendor code(214)

java=
..sql.SQLException: [unixODBC]client encoding mismatch

=A0 =A0 =A0at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdb=
c.java:6958)

=A0 =A0 =A0at sun.jdbc.odbc.JdbcOdbc.standard=
Error(JdbcOdbc.java:7115)

=A0 =A0 =A0at sun.jdbc.odbc.Jdbc=
Odbc.SQLDriverConnect(JdbcOdbc.java:3074)

Java Program:

----------------=
-------------------------------------

an" style=3D"white-space:pre"> DriverManager.setLogWriter(new PrintW=
riter(System.out)); >

Class=
..forName("sun.jdbc.odbc.JdbcOdbcDriver");

=3D"Apple-tab-span" style=3D"white-space:pre"> Connection con =3D Dr=
iverManager.getConnection (=A0"jdbc:odbc:postgres", "postgre=
s", "demopswd");=A0

odbc.ini

------------------------------------=
-----------

[ODBC Data Sources]

postgres =3D Postgr=
eSQL Test

[postgres]

Driver=
=3D/usr/lib/psqlodbc.so

Description=3DPostgreSQL DSN

DSN=3Dpostgres

S=
ervername=3D192.43.53.64

Username=3Dpostgres

Database=
=3Dpostgres

ReadOnly=3DNo

Servertype=3Dpostgres

iv>Port=3D5432

FetchBufferSize=3D99

ReadOnly=3Dno

Trace=3D1

TraceFile=3D/home/oralsh/odbc.trace

Debug=3D1

Debu=
gFile=3D/home/oralsh/odbc.debug

CommLog=3D1

<=
div>

[Default]

Driver =3D /usr/lib/libodbc.so

odbcinst.ini r>

-----------------------------------

[PostgreSQL=
]

Description pre"> =3D ODBC for PostgreSQL

Driver n>=3D /usr/lib/libodbcpsql.so

Setup style=3D"white-space:pre"> =3D /usr/lib/libodbcpsqlS.so

=
FileUsage =
=3D 1

space:pre">

I even tried to change encoding by running &=
quot;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<=
br>Prashantha K P

--0016e644cd9abc983e0469a01418--

Re: client encoding mismatch

am 11.05.2009 13:57:52 von prashanth k p

--0016362836892666330469a1b044
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi All,
I could resolve the issue by updating "Driver=/usr/lib/psqlodbc.so"
to"Driver=/usr/local/lib/psqlodbcw.so"

Thanks. I hope this would help other people also

--
regards
Prashantha K P

On Mon, May 11, 2009 at 3:32 PM, prashanth k p wrote:

> 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
>

--0016362836892666330469a1b044
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,

I could resolve the issue by updating s=3D"Apple-style-span" style=3D"font-weight: bold;">"Driver=3D/usr/lib=
/psqlodbc.so" to weight: bold;"> "Driver=3D/usr/local/lib/psqlodbcw.so" v>

Thanks. I hope this would help other people also

<=
div>

--=A0
regards
Prashantha K P

On Mon, May 11, 2009 at 3:32 PM, prashanth k p =
<konkodi210@gm=
ail.com> wrote:

x #ccc solid;padding-left:1ex;">Hi All,

I am running Pos=
tgre server in Windows platform. I have installed=A0psqlodbc-08.03.0400 odb=
c driver and=A0libiodbc-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 =A0below mentioned error

div>
SQLException: SQLState(22003) vendor code(214)
java=
..sql.SQLException: [unixODBC]client encoding mismatch

   =A0 =A0 =A0at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdb=
c.java:6958)
   =A0 =A0 =A0at sun.jdbc.odbc.JdbcOdbc.standard=
Error(JdbcOdbc.java:7115)
   =A0 =A0 =A0at sun.jdbc.odbc.Jdbc=
Odbc.SQLDriverConnect(JdbcOdbc.java:3074)

Java Program:
----------------=
-------------------------------------
pre"> DriverManager.setLogWriter(new PrintWriter(System.out)); style=3D"white-space:pre">

Class.forName("sun.jdbc.o=
dbc.JdbcOdbcDriver");
n>Connection con =3D DriverManager.getConnection (=A0"jdbc:odbc:postgr=
es", "postgres", "demopswd");=A0

odbc.ini
------------------------------------=
-----------
[ODBC Data Sources]
postgres =3D Postgr=
eSQL Test

[postgres]
Driver=
=3D/usr/lib/psqlodbc.so

Description=3DPostgreSQL DSN
DSN=3Dpostgres
S=
ervername=3D192.43.53.64
Username=3Dpostgres
Database=
=3Dpostgres
ReadOnly=3DNo
Servertype=3Dpostgres
iv>Port=3D5432

FetchBufferSize=3D99
ReadOnly=3Dno
Trace=3D1
=

TraceFile=3D/home/oralsh/odbc.trace
Debug=3D1
Debu=
gFile=3D/home/oralsh/odbc.debug
CommLog=3D1

<=
div>

[Default]

Driver =3D /usr/lib/libodbc.so

odbcinst.ini r>
-----------------------------------
[PostgreSQL=
]
Description =3D ODBC for=
PostgreSQL

Driver =3D /usr/lib/libodbcpsq=
l.so
Setup =3D /usr/lib/l=
ibodbcpsqlS.so
FileUsage =
=3D 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<=
br>Prashantha K P

--0016362836892666330469a1b044--