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

Re: client encoding mismatch help!

From: Frank R Callaghan <f(dot)callaghan(at)ieee(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: client encoding mismatch help!
Date: 2005-12-13 21:45:14
Message-ID: 200512131645.14888.f.callaghan@ieee.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks for the very fast reply Luf,

On Tuesday 13 December 2005 1:42 pm, Ludek Finstrle wrote:
> > I have installed 8.1 server on a FC4 system and loaded my
> > 7.3.2 database data (not too many problems) all is working well
> > except the odbc driver won't connect !
> > The database was built with no encoding options set, the driver
> > is psqlodbc-08_01_0102 with default options (but I have tryed many)
> >
> > The Driver Log file follows :=
>
> It seems you are trying psqlodbc on Windows. Am I right?
Yes Win2000 at the moment - Xp, 98 & ME to follow)
> It is more helpful when you post us mylog output (both - Global and
> DataSource settings).
I can't generate a log file as I don't have a C-Drive 
and the logpath seems to be hard wired!
>
> Do you try ANSI or Unicode driver? Does problem exist with both types
> of psqlODBC driver?
I only saw one stable msi driver ! (but I guess I looked in the wrong place)
>
> > Please help, I need to get this system up an running in production
> > pronto ;)
>
> I hope you don't mean in 5 minutes ...
No, 2 days (luxury)
>

I have solved the connect problem by rebuilding the database with
--encoding=SQL_ANSII, I guess the database default to some other
encoding schema - I bet it's in the documentation somewhere :) this
allows the windows ODBC drivers to work (mostly) but  now
fails with my datawindow objects :( it seem the from ODBC 2 -> 3
the TIMESTAMP field has changed some how, and the datawindow
can't deal with it (first guess)!

Is there some way to force the driver/database to use the old 2.0 ODBC
format ?

Cheers,

	Frank

In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-13 23:46:22
Subject: Re: client encoding mismatch help!
Previous:From: Ludek FinstrleDate: 2005-12-13 18:42:14
Subject: Re: client encoding mismatch help!

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