From: | "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem with special characters in password when using SQLDriverConnect |
Date: | 2013-05-13 14:04:57 |
Message-ID: | trinity-7255442f-f309-4ae2-914d-a8f99f67560a-1368453897636@3capp-gmx-bs63 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | ljwilson | 2013-05-13 14:13:22 | Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive? |
Previous Message | Heikki Linnakangas | 2013-05-13 13:51:20 | Re: psqlODBC 09.01.0100 Unicode version still crashes on long server messages? |