Re: problem connecting via ODBC when unicode (now in correct forum.). - Mailing list pgsql-odbc

From Adrian Klaver
Subject Re: problem connecting via ODBC when unicode (now in correct forum.).
Date
Msg-id 201101210657.30332.adrian.klaver@gmail.com
Whole thread Raw
In response to problem connecting via ODBC when unicode (now in correct forum.).  (Kim Mortensen <kimfmx@gmail.com>)
List pgsql-odbc
On Friday 21 January 2011 6:29:07 am Kim Mortensen wrote:
> Hi,
>
> I have have a question that annoys me incredibly.
>
> I have a "Login Roles" that include special chars like "ÆØÅ" (same in
> password) that accesses a view. however this is not possible, as the
> connector does not recognize the user.
>
> ------------------------------
> -----
> FATAL: no pg_hba.conf entry for host "127.0.0.1", user "ÆØÅ", database
> "mydb", SSL off.
> -----------------------------------
>
> However if I create another "Login Roles" with the name "abc" (same in
> password), I can successfull connect and access the view.
>
> I have almost tried all combinations of client_encoding, have tried to set
> configuration string on the connector.
>
> Database is build with: "...... --encoding=UNICODE --locale=C
> --lc-collate=C".
>
> If I use pgadmin, everything in the database looks perfect, and the unicode
> chars are represented correctly (Login role ÆØÅ exists).
>
> Any help much appriciated.
>
> Best Regards
> Kim Mortensen

To eliminate possibilities.
Can you connect to the database via means other than ODBC using the Role that
has the special characters?
What are the lines in your pg_hba file?

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-odbc by date:

Previous
From: Kim Mortensen
Date:
Subject: problem connecting via ODBC when unicode (now in correct forum.).
Next
From: Adrian Klaver
Date:
Subject: Re: problem connecting via ODBC when unicode (now in correct forum.).