Re: Problem with special characters in password when using SQLDriverConnect

Поиск
Список
Период
Сортировка
От Jan-Peter Seifert
Тема Re: Problem with special characters in password when using SQLDriverConnect
Дата
Msg-id trinity-6901c03f-0697-4493-bd86-779816915279-1368712107174@3capp-gmx-bs58
обсуждение исходный текст
Ответ на Re: Problem with special characters in password when using SQLDriverConnect  (Hiroshi Inoue <inoue@tpf.co.jp>)
Ответы Re: Problem with special characters in password when using SQLDriverConnect
Список pgsql-odbc
Hello,

> Gesendet: Mittwoch, 15. Mai 2013 um 17:31 Uhr
> Von: "Hiroshi Inoue" <inoue@tpf.co.jp>

> There already had been a patch in 09.00.0100 but this problem obviously persists in psqlODBC 09.01.0100 Unicode.
Maybethis has been patched in the ANSI version only? 

> I don't understand why ANSI drivers work.

That this has been fixed in the ANSI version only was just an assumption on my side, because the sudden increase of the
'knowncritical' characters seemed to be connected to the switch to the Unicode version of psqlODBC. 
It looks like the Unicode and the ANSI version use the 'same' internal functions though?

> Could you please try the dll on testing for 9.1.0300 at
> http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/index.html

Thank you very much for the patch!

We tested several passwords in connection with the SQLDriverConnect function and the Unicode version of psqlODBC:

password: %2  (two chars!)
submitted as:
…;UID=user;PWD=%2;                fails
…;UID=user;PWD={%2};              works

password: %25  (three chars!)
…;UID=user;PWD=%25;               fails
…;UID=user;PWD={%25};            works

password: }{
…;UID=user;PWD={}{};            fails

password: abc
…;UID=user;PWD=abc;               works (as expected)
…;UID=user;PWD={abc};              works

Password: a;bc
…;UID=user;PWD=a;bc;               fails (as expected)
…;UID=user;PWD={a;bc};             works

Best regards,

Peter


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Vote Release number of the next.
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Problem with special characters in password when using SQLDriverConnect