Thread: Problem with ODBC-Driver on a Windows 7/x 64
Hello,
we have some obscure problems accessing the database via ODBC driver PostgreSQL Unicode on Windows 7/x64
While accessing a table, i get the error invalid UTF-8 byte sequence detected near byte 0xfc
On two Windows 7/x64 clients accessing the same table is working fine. O two other Windows 7/x64 clients i get this error. I assume any system setting on the Windows 7/x64 clients is responsible for, but i have no idea !
Used Environment:
we have some obscure problems accessing the database via ODBC driver PostgreSQL Unicode on Windows 7/x64
While accessing a table, i get the error invalid UTF-8 byte sequence detected near byte 0xfc
On two Windows 7/x64 clients accessing the same table is working fine. O two other Windows 7/x64 clients i get this error. I assume any system setting on the Windows 7/x64 clients is responsible for, but i have no idea !
Used Environment:
- Databae server: Windows 2000 server with PostgreSQL 8.2, Database setting is UTF8
- Client: 4 Windows 7/x64 clients with PostgreSQL Unicode ODBC-Driver 8.01.02.00 installed with odbcad23 in SYSWOW64. All default settings are used.
- Two Windows 7/x64 clients are working well
- Two other Windows 7/x64 clients produce this error
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
![]() | Address | Josef.Springer@joops.com | Orlando-di-Lasso Str. 2 | D-85640 Putzbrunn |
![]() | Office | +49 (0)89 600 6920 | ||
![]() | Fax | +49 (0)89 600 69220 | ||
![]() | Web | http://www.joops.com |
![]() | (HRB München 86239) -- the software company -- |
Attachment
Hi Josef-san. Can you try newest version 09.01.0100? http://www.postgresql.org/ftp/odbc/versions/msi/ It can be used even if server version is 8.2. Regards, Hiroshi Saito (2012/08/03 16:18), Josef Springer wrote: > Hello, > > we have some obscure problems accessing the database via ODBC driver > PostgreSQL Unicode on Windows 7/x64 > While accessing a table, i get the error *invalid UTF-8 byte sequence > detected near byte 0xfc* > On two Windows 7/x64 clients accessing the same table is working fine. O > two other Windows 7/x64 clients i get this error. I assume any system > setting on the Windows 7/x64 clients is responsible for, but i have no > idea ! > > Used Environment: > > * Databae server: Windows 2000 server with PostgreSQL 8.2, Database > setting is UTF8 > * Client: 4 Windows 7/x64 clients with PostgreSQL Unicode > ODBC-Driver 8.01.02.00 installed with odbcad23 in SYSWOW64. All > default settings are used. > * Two Windows 7/x64 clients are working well > * Two other Windows 7/x64 clients produce this error > > Can everybody give me a help ? > > mit freundlichen Grüßen / best regards, > Josef Springer > (Geschäftsleitung/Management)
Hello Hiroshi,
yes i can try it. But i am little confused, why it works on some clients and on some clients not ! I assume this is because of some windows settings and not because of the driver. So i assume new driver version will not help.
Hiroshi Saito wrote:
yes i can try it. But i am little confused, why it works on some clients and on some clients not ! I assume this is because of some windows settings and not because of the driver. So i assume new driver version will not help.
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
![]() | Address | Josef.Springer@joops.com | Orlando-di-Lasso Str. 2 | D-85640 Putzbrunn |
![]() | Office | +49 (0)89 600 6920 | ||
![]() | Fax | +49 (0)89 600 69220 | ||
![]() | Web | http://www.joops.com |
![]() | (HRB München 86239) -- the software company -- |
Hiroshi Saito wrote:
Hi Josef-san.
Can you try newest version 09.01.0100?
http://www.postgresql.org/ftp/odbc/versions/msi/
It can be used even if server version is 8.2.
Regards,
Hiroshi Saito
(2012/08/03 16:18), Josef Springer wrote:Hello,
we have some obscure problems accessing the database via ODBC driver
PostgreSQL Unicode on Windows 7/x64
While accessing a table, i get the error *invalid UTF-8 byte sequence
detected near byte 0xfc*
On two Windows 7/x64 clients accessing the same table is working fine. O
two other Windows 7/x64 clients i get this error. I assume any system
setting on the Windows 7/x64 clients is responsible for, but i have no
idea !
Used Environment:
* Databae server: Windows 2000 server with PostgreSQL 8.2, Database
setting is UTF8
* Client: 4 Windows 7/x64 clients with PostgreSQL Unicode
ODBC-Driver 8.01.02.00 installed with odbcad23 in SYSWOW64. All
default settings are used.
* Two Windows 7/x64 clients are working well
* Two other Windows 7/x64 clients produce this error
Can everybody give me a help ?
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
Attachment
Hi. > yes i can try it. Thanks, anyway, it is pleasant operation. > But i am little confused, > why it works on some clients and on some clients not ! > I assume this is because of some windows settings and not because of the driver. > So i assume new driver version will not help. Um, Does pgAdminIII help you? (2012/08/04 22:58), Josef Springer wrote: > Hello Hiroshi, > > yes i can try it. But i am little confused, why it works on some clients > and on some clients not ! I assume this is because of some windows > settings and not because of the driver. So i assume new driver version > will not help. > > mit freundlichen Grüßen / best regards, > Josef Springer > (Geschäftsleitung/Management) > > > Hiroshi Saito wrote: >> Hi Josef-san. >> >> Can you try newest version 09.01.0100? >> http://www.postgresql.org/ftp/odbc/versions/msi/ >> It can be used even if server version is 8.2. >> >> Regards, >> Hiroshi Saito >> >> (2012/08/03 16:18), Josef Springer wrote: >>> Hello, >>> >>> we have some obscure problems accessing the database via ODBC driver >>> PostgreSQL Unicode on Windows 7/x64 >>> While accessing a table, i get the error *invalid UTF-8 byte sequence >>> detected near byte 0xfc* >>> On two Windows 7/x64 clients accessing the same table is working fine. O >>> two other Windows 7/x64 clients i get this error. I assume any system >>> setting on the Windows 7/x64 clients is responsible for, but i have no >>> idea ! >>> >>> Used Environment: >>> >>> * Databae server: Windows 2000 server with PostgreSQL 8.2, Database >>> setting is UTF8 >>> * Client: 4 Windows 7/x64 clients with PostgreSQL Unicode >>> ODBC-Driver 8.01.02.00 installed with odbcad23 in SYSWOW64. All >>> default settings are used. >>> * Two Windows 7/x64 clients are working well >>> * Two other Windows 7/x64 clients produce this error >>> >>> Can everybody give me a help ? >>> >>> mit freundlichen Grüßen / best regards, >>> Josef Springer >>> (Geschäftsleitung/Management) >> >>