auto translate=false in ADO.NET 2.0

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP: Password not found in ConnectionString for ADODB.Connection in v6.1 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to connect to MSDE with C# 3
Creating database connection in main thread 13
How do I do this VB6 ADO code in ADO .NET 1
OleDbDataAdapter, Connection String Question? 1
OleDbConnection Good SQLConnection Bad What Th? 3
ADO.NET Connectionstring+pooling 1

Top