Problem with special characters in password when using SQLDriverConnect

Поиск
Список
Период
Сортировка
Искать
От
Jan-Peter Seifert
Тема
Problem with special characters in password when using SQLDriverConnect
Дата
в 14:05:06
Msg-id
trinity-7255442f-f309-4ae2-914d-a8f99f67560a-1368453897636@3capp-gmx-bs63
Список
Дерево обсуждения
Problem with special characters in password when using SQLDriverConnect "Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>
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 "Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>
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 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>

Hello,
 
if you use SQLDriverConnect instead of SQLConnect the connection fails on special characters like ';', '(', ')' and '+'(?) within the password.
 
According to the documentation ( http://msdn.microsoft.com/en-us/library/windows/desktop/ms715433%28v=vs.85%29.aspx ) []{}(),;?*=!@  are special characters.
 
In order to pass the connection string to the driver intact you have to bracket the whole connection string ( or just the values ? - it looks like my English is not good enough for this article ).
 
There already had been a patch in 09.00.0100 but this problem obviously persists in psqlODBC 09.01.0100 Unicode. Maybe this has been patched in the ANSI version only?

Backslashes are still a problem? I wonder whether standard_conforming_strings has an effect on embedded backslashes.
 
Could you check, please?
 
Thank you very much,
 
Peter

В списке pgsql-odbc по дате отправления
От: Heikki Linnakangas
Дата:
От: ljwilson
Дата:
FAQ