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.
Error:
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
Cause:
Inappropriate database drivers.
Solution:
In the Data Source combo-box
Select Microsoft ODBC Driver For SQL server
instead of
Microsoft OLE DB Provider For SQL server
Happy Programing.....
ASP.Net, VB.Net, C#, Microsoft Visual Studio .Net, Quick Tutorials, .Net Tips and Tricks, asp.Net Tips and Tricks, Ajay Sharma's Blog, Java Script, javascript, HTML, .Net Sample Codes
Saturday, November 15, 2008
Thursday, November 6, 2008
Unable to validate data, ASP.net error
Error:
Unable to validate data, ASP.net 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)
Information:
This is an View state decoding error.
Cause:
The basic reason of this is the difference of key while encrypting and decrypting the viewstate data. Suppose an asp.net rendered a page with key1 and saved the page state in view state, meanwhile asp.net’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.
Solution
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:
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21321364.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312906
Unable to validate data, ASP.net 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)
Information:
This is an View state decoding error.
Cause:
The basic reason of this is the difference of key while encrypting and decrypting the viewstate data. Suppose an asp.net rendered a page with key1 and saved the page state in view state, meanwhile asp.net’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.
Solution
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:
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21321364.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312906
Subscribe to:
Posts (Atom)