Problem with special characters in password when using SQLDriverConnect

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

Responses

Browse pgsql-odbc by date

  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?