PC Review


Reply
Thread Tools Rate Thread

auto translate=false in ADO.NET 2.0

 
 
Adam Right
Guest
Posts: n/a
 
      13th Dec 2007
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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CustomValidator Returns False, but False is Ignored DJ Microsoft ASP .NET 3 27th Dec 2007 10:29 AM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 Matt Simpson Microsoft Excel Programming 0 6th Aug 2007 08:11 PM
If formula result is false, how do I auto-delete that rows? =?Utf-8?B?amJyZW5uZXI1MQ==?= Microsoft Excel Worksheet Functions 1 16th Nov 2005 05:24 PM
Auto Excel workbook close: save= false during an auto subroutine =?Utf-8?B?dG9td2FzaGVyZTI=?= Microsoft Excel Programming 10 16th Jun 2005 06:23 AM
True Or False, no matter what... it still displays the false statement rocky640 Microsoft Excel Programming 2 13th May 2004 04:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:31 AM.