Connection: Password and the char ';'

gozul · Post by **gozul** » 24.01.2009, 08:38

Hello,
The connection don't work if I use the ';' char in password.
I changed the delimiter from ';' to '¿' and it works.
Thanks.

Post by **mdaems** » 29.01.2009, 22:56

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

gozul · Post by **gozul** » 24.04.2009, 11:02

Thanks for answer.
I tested with Oracle db. 10.2.0

Post by **mdaems** » 03.05.2009, 23:15

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