-
March 14th, 2014, 07:24 AM
#1
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
-
March 16th, 2014, 08:03 PM
#2
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.
-
March 17th, 2014, 01:09 AM
#3
Re: Escape ;(semicolon) in odbc connection string in app.config
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?
-
March 17th, 2014, 09:30 PM
#4
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|