Saturday, November 15, 2008

Microsoft SQL Server DTS (Data Transformation Services) Import/Export Wizard Error

If you are facing problems in “Choose a destination” option while importing and exporting data using Microsoft SQL Server DTS (Data Transformation Services) Import/Export Wizard, specifically the error mentioned below then this post may be helpful for you to get it solved.

DTS Import/Export Error
Error Source: Microsoft OLD DB Provider for SQL Server
Error Description: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied

Inappropriate database drivers.

In the Data Source combo-box
Select Microsoft ODBC Driver For SQL server
instead of
Microsoft OLE DB Provider For SQL server

Happy Programing.....

Thursday, November 6, 2008

Unable to validate data, error

Unable to validate data, error at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength) at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)

This is an View state decoding error.

The basic reason of this is the difference of key while encrypting and decrypting the viewstate data. Suppose an rendered a page with key1 and saved the page state in view state, meanwhile’s key is changed to key2, now when some server side event will occur on page the viewstate will get decrypted and this error will occur as the old view state is now not valid due to a different encryption key.

It may occur when you open a page for along time and after that do some events on that.

Fix the key in your web.config file, so that only one key is used to encrypt and decrypt the viewstate data.

For more information visit:;en-us;Q312906