Provider cannot be found. It may not be properly installed

PowerShell Help
1

I’m trying to query an access db/mdb file to get info, but get the above error when I open it. I can’t switch to 32 bit (if that would help) because everything I do is 64 bit.

I’m writing a powershell 5.1 script to query info from a mdb file based on [this article][1]. I get this error message when I try to open/access an mdb file:

MDB Open next
Provider cannot be found. It may not be properly installed.

I’m pretty sure I need to adjust my connection info according to what I have installed. This is what I’m doing:

   $pathViewBase = 'C:\Data\EndToEnd_view\' #View dir. 
   $XML_MDB_Dirs = @('\AppText.mdb') #more files later
   foreach($mdbFile in $XML_MDB_Dirs)
   {
      $pathToMdb = Join-Path -Path $pathViewBase -ChildPath $mdbFile
      if(Test-Path $pathToMdb)
      {
        $cn = new-object -comobject ADODB.Connection
        $rs = new-object -comobject ADODB.Recordset
        Write-Host "MDB Open next" -ForegroundColor DarkCyan
        $cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $pathToMdb") ###error this line
        Write-Host "Open done" -ForegroundColor DarkCyan
        $rs.Open(“SELECT TOP 1 [TableName].[Message Description],
            [TableName].[Column1]
            FROM [TableName]
            WHERE [TableName].[Message Description] = 'ERROR'”,
            $cn, $adOpenStatic, $adLockOptimistic)
        $rs.MoveFirst()
        Write-Host "Message value obtained for ERROR: " $rs.Fields.Item("Name").Value
        Break ##########################
      }#test-Path
}#foreach

I found this regarding [odbc connections][2], and it seems to say I need to adjust my connection info. Looking at what’s installed on my computer, I see this, but I’m a little unclear what I need to adjust my open code to use. Would I need to replace ‘Microsoft.Jet.OLEDB.4.0’ with ‘SQLNCLI11.dll’?
odbc

I checked,

(Get-WmiObject Win32_OperatingSystem).OSArchitecture

and I am running 64 bit powershell, so since I installed accessdatabaseengine_x64.exe (and rebooted), that’s correct. But I still get the same error. I’m not sure if there’s something I could check to see if it’s installed correctly, or if I need to use SQLNCLI11.0 as the provider instead of Microsoft.Jet.OLEDB.4.0, or if I need to add “using” at the top? Or do I need to check if a powershell module is installed?

Update:
I looked again and it looks like the Access Driver turned up in the list now, but I still get that error. I’ll try what people suggested overnight and keep you posted. It won’t let me post the new picture since I’m a new user.

2

Although you dont show the exact error you are getting, I messed with this a while ago and never got it working, so I gave up and found another way. If this is the error you are getting, please make sure you post the solution if you find it as I am dying to know.

Provider cannot be found. It may not be properly installed.
At C:\Yada\Yada\Yada\queryAccessDB.PS1:9 char:1
+ $cn.Open("Provider = Microsoft.JET.OLEDB.4.0;Data Source = $db")
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (:) [], COMException
    + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException
1 Like
3

Hi, welcome to the forum :wave:

After installing the Access Database Engine 64-bit, try the following connection string:

$cn.Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source = $pathToMdb")

Worth noting that you don’t have any Access Drivers in your screenshot, which should be visible after installing the Access Database Engine so you may have an installation problem as well as a problem with your connection string.

1 Like
4

Matt, I have the following and am basically using the same code as the OP … any suggestions on the error I am getting?
image

I suspect it is my connection string but everything I found in google suggests what I am using.

I tried the string you provided and got this:

Unrecognized database format 'C:\Yada\Yada\Yada\data.mdb'.
At C:\Yada\Yada\Yada\queryAccessDB.PS1:9 char:1
+ $cn.Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source = $db")
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (:) [], COMException
    + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException
5

@tonyd, Well it looks like it fixed the provider error :slight_smile:

I’m not sure what would cause that, I’d have to set up a database here and see if I can replicate it.

6

Got it figured, changed your string to this since my version said 16:

"Provider=Microsoft.ACE.OLEDB.16.0;Data Source = $db"

Thanks Matt :slight_smile:

2 Likes
7

Yes, that’s my error message. It’s within the top 10 lines of my question. :slight_smile:

8

Thank you so much! I’ve been trying to figure this out for days! The error message went away. Awesome. :grinning_face_with_smiling_eyes:

I’m not sure who posted the answer first, but it won’t let me accept both solutions. Thank you all!

9

Please feel free to take a look at my new topic, since this error message went away, and when I try to get data retrieved, I get a new error that I’m trying to figure out.

10

Pretty sure Matt had the answer :slight_smile:

Thanks Matt.

1 Like