We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

MSAccess Error: Class does not support Automation or does not support expected interface

Thread ID:




132260 Aug 23,2017 11:00 AM UTC General Discussion 0
Tags: General Discussion
Asked On August 23, 2017 11:00 AM UTC

The issue is that it's searching out the OLE Automation reference in C:WindowsSysWOW64stdole2.tlb

That is first-rate for 64bit customers however now not for 32bit. How might I repair this?

How do I discover if the reference is used Automation anywhere ? i'm afraid of virtually doing away with the reference then finding out it's being used someplace.

replace: underneath is where the error is triggered:

Error -->  Set Cnxn = New ADODB.Connection
         With Cnxn
           .Provider = "MSDataShape"
           .Properties("Data Provider").Value = "SQLOLEDB"
           .Properties("Data Source").Value = dbserver
           .Properties("User ID").Value = username
           .Properties("Password").Value = password
           .Properties("Initial Catalog").Value = dbname
           .CommandTimeout = 120
           .ConnectionTimeout = 120
        End With


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon