Problem with special characters in password when using SQLDriverConnect
От
Jan-Peter Seifert
Тема
Problem with special characters in password when using
SQLDriverConnect
Дата
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
Дата: