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

Re: problem connecting via ODBC when unicode (now in correct forum.).

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Kim Mortensen <kimfmx(at)gmail(dot)com>
Subject: Re: problem connecting via ODBC when unicode (now in correct forum.).
Date: 2011-01-21 14:57:30
Message-ID: 201101210657.30332.adrian.klaver@gmail.com (view raw or flat)
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

pgsql-odbc by date

Next:From: Adrian KlaverDate: 2011-01-21 16:06:06
Subject: Re: problem connecting via ODBC when unicode (now in correct forum.).
Previous:From: Kim MortensenDate: 2011-01-21 14:29:07
Subject: problem connecting via ODBC when unicode (now in correct forum.).

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