AnsweredAssumed Answered

ADODB.Connection Error

Question asked by dr.hong on Feb 26, 2019
Latest reply on Feb 27, 2019 by varunk

When we run the script we get the following Error on some PC

 

<Script>

              Dim strConn, DefaultConnection

              Set DefaultConnection = CreateObject("ADODB.Connection")

              strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MentorGraphics\DxDB\MC_DXDB.mdb"

Line90 : DefaultConnection.Open strConn

 

<Run Result>

Source:'ADODB.Connection'

Line:90 Char:4

Error:0x800a0e7a 'Provider cannot be found. It may not be properly installed.

 

 

does not work with

Windows server 2016 Standard

MS Office 2016

 

Windows 7

MS Office 2016

Outcomes