Re: Character special in ADO ConnectionString.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxx> wrote in message
news:%23LpyH%2302GHA.3656@xxxxxxxxxxxxxxxxxxxxxxx
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




.