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
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