Page 1 of 1
Connection: Password and the char ';'
Posted: 24.01.2009, 08:38
by gozul
Hello,
The connection don't work if I use the ';' char in password.
I changed the delimiter from ';' to '¿' and it works.
Thanks.
Posted: 29.01.2009, 22:56
by mdaems
Can you tell us what db server you're working on? Maybe we can fix this issue by the right escaping/quoting of the password.
Mark
Posted: 24.04.2009, 11:02
by gozul
Thanks for answer.
I tested with Oracle db. 10.2.0
Posted: 03.05.2009, 23:15
by mdaems
Somebody should look here (ZdbcOracle.pas, "Open" method):
FPlainDriver.AttrSet(FSessionHandle, OCI_HTYPE_SESSION, PAnsiChar(string(Password)),
Length(Password), OCI_ATTR_PASSWORD, FErrorHandle);
This function is invokes the OCI call "OCIAttrSet". Now the big question is how this OCI call expects the input is encoded/escaped for a password value. Can you find out? I'm not an OCI expert and don't have an oracle installation to try.
Mark
Mark