auto translate=false in ADO.NET 2.0

  • Thread starter Thread starter Adam Right
  • Start date Start date
A

Adam Right

Hi All,

I have a database with [SQL_Latin1_General_CP1_CI_AS] collation on Sql
Server 2005, for this collation i have to use
SQLOLEDB provider in my C# application because of character problems.
And it works fine with SQLOLEDB driver if i use it with auto translate=false
parameter.

But it is very slow.

If i use default connection string of ADO.NET the character set goes wrong.

The following is my connection strings:

For SQLOLEDB:
"Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=newsa;PASSWORD=######;auto translate=false;Data07;Data Source=ServerSql"
For ADO.NET 2.0:
"Server=ServerSql;Database=Data07;Uid=newsa;Pwd==######;"

Is there any way to use auto translate=false parameter in ADO.NET 2.0 ?
Thanks in advanced for any advice....

Adam
 
Back
Top