Open sagar-gopale opened 3 months ago
Are you running on a macOS Intel or M1 machine ?
Where did you obtain the indicated MongoDB 1.4.5 ODBC drivers from ?
If you create the ODBC DSN using the iODBC Administrator directly , rather than in MSExcel, does the same error occur creating the ODBC DSN in the iODBC Administrator ?
@HughWilliams
iODBC does not provide an ODBC driver just the ODBC Driver Manager components, so some thing or someone else must have installed the MongoDB ODBC 1.4.5 driver on your machine.
What is in the /Library/ODBC/odbc.ini
and /Library/ODBC/odbcinst.ini
file on your machine, which should provide the file name of the ODBC driver and location, and might be a hint as to its origin ?
@sagar-gopale Don't try add DSN under MS Excell. Run iODBC Administrator App directly and create new DSN. MS Excell is sandboxed app, so if you run iODBC Administrator under MS Excell, you must have issues with files access.
@sagar-gopale Also look at => https://github.com/openlink/iODBC/issues/29#issuecomment-476630516 and https://github.com/openlink/iODBC/issues/97 If your MongoDB ODBC driver uses some dynamic libs that is installed for example to /usr/local/libs or MongoDB ODBC driver installed to /usr/local/libs or etc, so MongoDB ODBC driver could NOT be loaded by MSExcell , because sandboxed app doesn't have access to this locations.
I am using
mongosqld
utility is also running and it is able to sample schemas from MongoDB(as seen in logs).Below is what my
mongosqld
config looks like for local mongodb connection.I am using below values when adding
System DSN
in MS Excel.I can see below drivers in MS Excel when adding System DSN. I have tried with both.
I get below error dialog when I try to create DSN.
I am not sure how to debug this. I have tried the solution at https://github.com/openlink/iODBC/issues/34. Changing the permission of
odbcinst.ini
that is present in /Library/ODBC. NOTE: I am the administrator on this system.