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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Platform:

Replies:

132260 Aug 23,2017 07:00 AM General Discussion 0
loading
Tags: General Discussion
soujanyanaganuri
Asked On August 23, 2017 07:00 AM

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
           .Open
        End With

CONFIRMATION

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.

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.

;