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.
"Format of the initialization string does not conform to specification starting at index 35"
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