ConnectString property issue

spn · Post by **spn** » Mon 28 Jan 2008 20:03

I have upgraded from odac v5.80 to lastest version v6.25.1.13 and I noticed a difference for the ConnectString property. The new version has a problem when the user name or the password contain dash characters (-).

Ex. Connect :String = "ABC-DFR/1234-E@oracle:1521:sid"
the result: ConnectString value is "ABC".

Is it a bug?

Plash · Post by **Plash** » Tue 29 Jan 2008 14:59

You should quote username and password in the connect string if they contain special characters.

Code: Select all

  OraSession.ConnectString := '"ABC-DFR"/"1234-E"@oracle:1521:sid'

We'll make changes in the next ODAC build. So only usernames and passwords containing '/', '@' or space will require quotation.