Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
I've received an email from a friend on yesterday. the content is below! just to share.
Hello,
I am facing a problem regarding .NET deployment issue. My team developed an application on C# on Windows XP and that application runs perfectly on all Machines running Windows XP but this application generates an unhandled Exception "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done."
This Exception is thrown in condition...
(i) When I run my applicatio on the Machine running Windows 2000.
(ii) When I set the compatibility of application to "Windows2000 " on Windows XP Operating System.
Code
----
Conn = new OleDbConnection();
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\MAP1.4.mdb;";
Conn.Open(); <---- Exception Thrown at this Statement
If anyone of u have any idea about handling this so plz reply me.
Regards
Adeel
------------------------------------------------------------------------------------------------------------------------------------
There has 2 possible causes to fire this exception:
1) There should have an entry “OLDDB_SERVICES“ in CLSID in registery when using ADO connection.
2) Error occur in your connection string
Reference for case 1
http://support.microsoft.com/kb/269495/EN-US/
Reference for case 2
http://www.connectionstrings.com