Обсуждение: 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:

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

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

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.

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)

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