Parmeshwar’s Homespace

This Exception mainly comes when we are trying to copy a row from one DataTable to another Datatable.

Here is Problem:

Dim tempDS as Dataset For each temprow as DataRow in objDS1.Tables(0).select(”ID=’xyz’”)

tempDS.Tables(0).rows.add (temprow) Next row Instead ,do the following:

Dim tempDS as Dataset For each temprow as DataRow in objDS1.Tables(0).select(”ID=’xyz’”)

tempDS.Tables(0).ImportRow (temprow) Next row

When we are using SQL server 2000 on Windows server 2003 machine and application on Windows XP/Professional and changed machine location,the same application which was running previously,started giving the above error.After lots of search, we found that the problem resulted due to change of IP address/ Port or domain of client machine on which application is hosted. What was happening - MSDTC on client system was able to communicate with MSDTC on database server but vice versa was not possible as the DNS setting is yet not reflected in DB server. This will take some time to reflect,therefore Windows server 2003’s MSDTC check for the previous IP/domain and fails to respond resulting in above error. The solution is - Either restore the IP address to original OR wait for around 24 hrs ..it will solve the problem.

Here is KB:MSDTC fails to mutually authenticate when computers do not run in the same domain explaining the Mutual authentication failure when running application and Database server on different domains.

Also if you are running your application on Windows XP with SP2 applied, check for the proper configuration for MSDTC. Here is a documentation at Microsoft Technet: Changes to Functionality in Microsoft Windows XP Service Pack 2 Any comments welcome !!

Following is a nice link wherein you can find all shortcuts related to VS .NET 2003 http://www.codinghorror.com/blog/files/visual%20studio%20net%202003%20keyboard%20shortcuts.html

This is a very nice article which demonstrate how to generate these using program.