« Previous Next »

• 08-31-2008, 4:08 AM

  foxcrofts Joined on 08-31-2008, 7:54 AM Posts 2

  Multiple-step OLE DB operation generated errors... Reply Contact Hi  Only have this problem since on XP SP3 - cant connect to SQLEXPRESS.  This all works on my machine with XP SP2 and SQLEXPRESS. The full error is: Provider (0x80040E21) Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I have being surfing for 2 days looking for a solution and have tried every prosoped solution I could find on the web: 1.  Re-install MDAC 2.8 with Windows 2000 compatibility (to ensure re-install) 2.  Checked registery for OLE SERVICES values 3.  Ran XP SP3 Hotfix that was supposed to resolve this I can login to SSIS with the username and password in my connection string and execute sqls. Connection string: "Provider=SQLOLEDB; Data Source=.\SQLEXPRESS; Initial Catalog=Certification;  Integrated Security=True; User ID=xxx; Password=xxx;" Using ADO connection: CreateObject("ADODB.Connection")  Asp page fails on conn.open. HELP!!! Regards Mark

• 09-02-2008, 2:34 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,187	Re: Multiple-step OLE DB operation generated errors... Reply Contact Have you seen this? http://www.aspfaq.com/show.asp?id=2288 Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 09-03-2008, 4:17 AM

  In reply to

  foxcrofts Joined on 08-31-2008, 7:54 AM Posts 2	Re: Multiple-step OLE DB operation generated errors... Reply Contact Yes.  My page fails before the actual sql is executed - fails when the connection is setup. If I change password then I get login FAILED so the database connection is almost working - but not.

• 09-03-2008, 9:32 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,187	Re: Multiple-step OLE DB operation generated errors... Reply Contact OK - you may get better support on this in a SQL Server forum ... Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/