Punith Kumar

Punith Kumar

  • NA
  • 3
  • 5.3k

Escape ;(semicolon) in odbc connection string in app.config

Mar 14 2014 7:41 AM

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/" ,&quot; ,{}
But no use. Still facing this error. I have tried putting all the escape sequences 
 

Answers (3)