Semicolon in Oracle connection string

Question

this is my Powershell code :

[void][System.Reflection.Assembly]::LoadFile("C:\oracle_script\DLL\Oracle.ManagedDataAccess.dll")

$OracleConnexion = New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=test;Password=v79;aw;Data Source=192.30.1.5/PROD")

I have an issue because my password contain a semicolon : v79;aw

I already tried this :

 New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=test;Password='v79;aw';Data Source=192.30.1.5/PROD")

But it didn't work, because it takes simple quotes in password..

How can I resolve it?

Thanks

Use `"` instead of `'`: `'User Id=test;Password="v79;aw";Data Source=192.30.1.5/PROD'` — Mathias R. Jessen, Feb 11 '16 at 11:20
The rules for escaping special characters are described here: https://www.connectionstrings.com/formating-rules-for-connection-strings/ — David Brabant, Feb 11 '16 at 12:17

score 2 · Accepted Answer · edited May 23 '17 at 12:07

2

Oracle password can be enclosed between double quotes (oracle password must not contain double quotes). The back ticks allow to escape double quotes in a string enclosed by double quotes in Powershell.

New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=test;Password=`"v79;aw`";Data Source=192.30.1.5/PROD")

see also Escaping quotes and double quotes

edited May 23 '17 at 12:07

Community

1
1

answered Feb 11 '16 at 14:37

Nahuel Fouilleul

18,726
2
31
36

Semicolon in Oracle connection string

1 Answers1