Escape ;(semicolon) in odbc connection string in app.config
I have created a windows form with certain fields. I am trying to interact with oracle database through ODBC DSN connections.
I have an issue in the below connection string in app.config .
In the connection string password contains semicolon(here abc;45). I am getting an error:
"Format of the initialization string does not conform to specification starting at index 35" while i am trying to access this connection string using OdbcConnection connection = new OdbcConnection(connection_string); in C# code.
Below is my connection string.
<add name="ConnectionString_T1" connectionString="DSN=CLA_T5;Uid=abc;Pwd=abc;45" providerName="System.Data.Odbc" />
I pass the connection string to the below class.
OdbcConnection connection = new OdbcConnection(connection_string);
PS: I tried putting this password in double quotes/single quote/" ," ,{}
But no use. Still facing this error. I have tried putting all the escape sequences
Re: Escape ;(semicolon) in odbc connection string in app.config
It isn't an escape issue. The problem is OdbcConnection doesn't allow the semi-colon.
Re: Escape ;(semicolon) in odbc connection string in app.config
Quote:
Originally Posted by
Arjay
It isn't an escape issue. The problem is OdbcConnection doesn't allow the semi-colon.
[Punith]: Is there any way to work with passwords like this using ODBCConnection. Any other alternatives?
Re: Escape ;(semicolon) in odbc connection string in app.config
Try is SQL Management Studio. It's easier on error. Points to a specific location