search

aws / amazon-documentdb-odbc-driver

Apache License 2.0
5 stars 3 forks source link

ODBC Driver x64 (ODBC: ERROR [IM003] #191

Open DrFalken1976 opened 1 year ago

DrFalken1976 commented 1 year ago

Hi,

I Install in my computer a x86 And x64 version, and muy ODBC test from odbc config works fine. but when try connect from excel or PowerBI, system returns next error message:

"Specified driver could not be loaded due to system error 126. The specified module could not be found Amazon DocumentDB, C:\Program Files\Amazon DocumentDB\ODBC Driver\documentdb.odbc.dll"

any idea?

alinaliBQ commented 10 months ago

Hello, there are several possible causes of the issue:

  1. maybe the issue you're experiencing is related to this (PowerBI Desktop cannot load the DocumentDB ODBC driver library)?
  2. Or it might be due to the Excel/PowerBI not being able to access any folder under C:\Program Files\.
  3. DSN might be pointing to wrong driver. Please make sure you're using the same DSN as the DSN used in ODBCTest, or create a new DSN after driver installation.
ItWorksOnMyMachine commented 5 months ago

I had this same issue. My instance of Power BI Desktop was installed from the Store. I uninstalled it and reinstalled it from the link in alinaliBQ's response and everything is working fine now.

DrFalken1976 commented 5 months ago

I no longer spend a single second on the DocumentDB connector, neither AWS directly gives me an answer. Quick and simple solution, move all my DBs to MongoDB, easy and fast