Character special in ADO ConnectionString.

Hi,

we have a function that defines the password of the user access the data
base. This function was written initially in Delphi and the access to the
data base is ADO. In this environment the access is made without problems.
In C# with ADO.net when attributing the password is returned the following
error: Format of the initialization string you donate not conform you
specification starting at index 89.

Code example:
string sConn = "Data Source=10.28.0.6;Initial Catalog=dsMatriz;Persist
Security Info=False;User ID=teste;Password={0}";
byte[] b = new byte[] { 9, 13, 10, 28};
sConn = string.Format(sConn, UTF8Encoding.UTF8.GetString(b));
SqlConnection conn = new SqlConnection();
conn.ConnectionString = sConn; // Exception. Format of the initialization
string does not conform to specification starting at index 89.
conn.Open();

Any idea about this error?

Thanks,

Jefferson Valim
JBS Group
Brazil

Hi Jefferson,

Try with SqlConnectionStringBuilder instead.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Jefferson Valim" <jmvalim@newsgroups.nospan> wrote in message
news:%23LpyH%2302GHA.3656@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> we have a function that defines the password of the user access the data
> base. This function was written initially in Delphi and the access to the
> data base is ADO. In this environment the access is made without problems.
> In C# with ADO.net when attributing the password is returned the following
> error: Format of the initialization string you donate not conform you
> specification starting at index 89.
>
> Code example:
> string sConn = "Data Source=10.28.0.6;Initial Catalog=dsMatriz;Persist
> Security Info=False;User ID=teste;Password={0}";
> byte[] b = new byte[] { 9, 13, 10, 28};
> sConn = string.Format(sConn, UTF8Encoding.UTF8.GetString(b));
> SqlConnection conn = new SqlConnection();
> conn.ConnectionString = sConn; // Exception. Format of the initialization
> string does not conform to specification starting at index 89.
> conn.Open();
>
> Any idea about this error?
>
> Thanks,
>
> Jefferson Valim
> JBS Group
> Brazil
>
>