[Mono-dev] Patch to add the support of TDS 8 to SqlClient

[Dmitry Key]

Hi, Naggapan!

I attached my test program. It's very simple but cover all new features that 
I added. This sample uses 'pubs' database and 'employee' data table. Also 
you can change column collation in the 'employee' table.

Actually the most interestring stuff is Ssl/Tls settings for the SQL Server 
2000/2005. I used the info taken from 
http://support.microsoft.com/kb/316898.

The certificate was generated as

makecert -r -n "CN=yourcert" -p12 yourcert.p12 yourpasswd

This Certificate was imported as DER-encoded X.509 (.CER) file:

certmgr -add -c Trust yourcert.cer

Please take into account that in the string "CN=yourcert" the parameter 
"yourcert" has to coincide with the SQL Server host name. It corresponds to 
the behaviour of the SqlClient in the .Net Framework 1.1. The ADO.NET 2.0 
supports the additional parameter TrustServerCertificate that can be 
implemented easily in the Mono-2.0 (TdsComm.CertificateValidation should 
return true if TrustServerCertificate is true|yes).

With best wishes,
Dmitry S. Kataev

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SqlClient.cs
Type: application/octet-stream
Size: 1135 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20070112/8ff8e174/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SqlClient.exe.config
Type: application/octet-stream
Size: 223 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20070112/8ff8e174/attachment-0001.obj