Am 08.09.2004 um 08:21 schrieb Philippe Lang:
> Hello Christof,
> What ODBC driver are you using?
> There are 3 drivers: Postgresql, Postgresql Legacy, Postgresql Unicode.
I'm not so sure, but I think it is called 'Postgresql' as I remember
seeing this option somewhere in the ODBC dialogs.
There were no other options to choose from.
The servers' log file shows me "select pg_client_encoding()" and
directly after "set client_encoding to 'UTF8'", hence I assume it is a
Unicode version. I'm currently not at the Windows machine, but I could
send logfile snippets later, if necessary.
> I'm using the first one "Postgresql", (snapshot 208 or 209), with
> Access 2000, 2002 or 2003 without any problem. I haven't tried Access
> My databases are encoded in LATIN1 as well, for French. Update with
> accents are fine, at least with PGSQL 7.3.x and 7.4.x.
Sound good. Does your server also run on Windows (cygwin)?
Perhaps I give 7.4. a try on cygwin, that's easier than switching to a
newer Access version.
Thanks and best regards,
-- gl.aser . software engineering . internet service
-- Doelitzer Strasse 37 . D-04277 Leipzig . fon +49-341-303 20 51
-- http://gl.aser.de/ . sms +49-177-779 28 43 . fax +49-341-303 20 52
In response to
pgsql-odbc by date
|Next:||From: Michael Anderson||Date: 2004-09-08 17:51:35|
|Subject: Connection Failure|
|Previous:||From: Richard Huxton||Date: 2004-09-08 07:22:06|
|Subject: Re: new to Unixodbc: can't connect to Postgresql|