Posts

Showing posts from February, 2009

Tool to transfer data among SQL Servers

Since I have no bulk read and write permission to my SQL Server database at my previous hosting plan, I can not use SQL Server data import/export tool to transfer my data to my new hosting database server. I spent a few nights and developed a small tool that connects to any sql server using OLE DB, fetch all tables in the database, and fetch all data from any table page by page. Based on this function, I have successfully implemented the tool to transfer any amount of data between two remote sql servers. The tool can not solve one problems so far. If any field is auto increase, the backup may not succeed. The project has been uploaded to popfly. SQLViewer

MachineKey and validation key configuration problem

I got the following error when I clicked a radio button on my web page after a couple of hours. This error only happens when the web page was loaded quite a little while ago and then you try to refresh it. It means that your post back request was sent to another machine of the web farm that has a different ValidationKey. ============ Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be ...