Last time I wrote a post on MSDTC under Vista. Here I’d like to talk a general MSDTC issue, which is not Vista-specific. Internally MSDTC uses NetBIOS names and passes them to RPC to talk to remote machines. This requires both server and client to be able to resolve each other’s machine name. Sometimes things …
Background Consider the following two scenarios: 1. You have implemented a .NET application accessing a specific COM+ service with automatic transaction processing. You derived a class from ServicedComponent, set the Transaction attribute for the class, and applied the Automatic attribute to a method which opens a SqlConnection. 2. Inside a TransactionScope, you wanted to open …
Continue reading “Using MSDTC between Vista clients and Windows 2000 servers”
If you don’t know what Bedlam DL3 means, I encourage you to read this blog entry You Had Me At EHLO… : Me Too! Yesterday, a similar event happened, in a smaller scale though. Someone sent an announcement email to the Bluehat Alert DL with more than 1000 members at the company. The email was …
Continue reading “Bluehat message recall incident: flashback to Bedlam DL3”
Under some circumstances (such as with certain network bandwidth), you might get a general network error in .Net Framework 1.1 when executing a query that takes longer than SqlCommand.CommandTimeout value. This has something to do with how SqlClient 1.1 deals with timeout. Basically we track the timeout value by decrementing it each time after we …
Continue reading “General Network Error in .Net Framework 1.1”
http://support.microsoft.com/kb/913764/ The KB article didn’t say a lot of details about this bug. Usually the following conditions have to been met in order to trigger the bug: 1. Query must run against sql2000 (Sql2005 works fine) 2. The table name has to include 3 or more dots, ie: [A.B.C.D.E] 3. There has to be an …
There was a bug in SqlClient which could cause high CPU use. The scenario is a SqlClient application sends an attention to Sql Server but receives no acknowledgement from the server because the connection is broken. The bug lies in the logic of reading server’s response from the wire. We buffer the incoming data from the wire. …
Now you don’t have to log in in order to make a comment in my blog.
Today Bill Gates announced his transition plans: http://www.msnbc.msn.com/id/13348456/ Essentially in two years, Bill Gates will transition away from a daily role at Microsoft to focus on the charitable work of the Bill & Melinda Gates Foundation. However, he will continue to be the company’s chairman after the two-year transition period. Bill Gates always is my …
For certain size of data, SqlBulkCopy.WriteToServer() may throw a timeout exception, although it won’t happen when MARS is turned on. The problem is caused by a bug in the code for handling some boundary scenarios. The workaround is to apply this patch: http://support.microsoft.com/kb/913177/
Exception Type: System.Data.SqlClient.SqlException Number: 3988 Message: New transaction is not allowed because there are other threads running in the session If you have ever seen this type of exception when talking to RTM SQL Server 2005 (but never saw it with the Beta version of the server), it’s likely that you have an open data …