A 64-bit unicode ODBC driver for connecting to Atlas Data Federation using the MongoSQL dialect.
If you're looking for an ODBC driver to use with the MongoDB Connector for BI, please see the mongodb/mongo-bi-connector-odbc-driver repository.
You can download the MongoDB ODBC Driver from MongoDB Download Center.
Copy link
and use the URL while following the instructions to validate MongoDB packages described here.⚠️ For this step, download and import the MongoDB ODBC Driver public key using this url :
https://pgp.mongodb.com/atlas-sql-odbc.asc
Note: users can utilize the built-in driver manager.
Update the values of Driver
, Pwd
, Server
, User
, and Database
in setup/setupDSN.reg
. The value of Driver
should be the absolute path of mongoodbc.dll
. This file should be located in either the mongo-odbc-driver/target/debug
directory or in the release directory.
For 32-bit architectures, modify the file path HKEY_LOCAL_MACHINE\SOFTWARE
in setupDSN.reg
so that it is instead HKEY_LOCAL_MACHINE\Wow6432Node\SOFTWARE
.
Run reg import "setup/setupDSN.reg"
in order to populate the registry editor with the new entries. Alternatively, simply double click on the setupDSN.reg
file.
Run reg query "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers"
to verify that MongoDB Atlas SQL ODBC Driver
has been installed successfully.
There should be a new entry called ADF_TEST
under ODBC/ODBC.INI
with the following subentries:
database: <database name>
pwd: <password>
server: <server>
user: <user>
Run reg query "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MongoDB Atlas SQL ODBC Driver"
to determine if the registry editor was updated successfully. There should also be a new entry called ADF_ODBC
under ODBC/ODBCINST.INI
with the following subentries:
Driver: <path to dll>
Setup: <path to dll>
Open the Microsoft ODBC Administrator (64-bit) and verify that "MongoDB Atlas SQL ODBC Driver" appears under "System DSN".
The driver is a Unicode only driver and does not support ANSI functions. Additionally, the following ODBC functions are currently not supported by the driver.
Function |
---|
SQLBindParameter |
SQLBrowseConnectW |
SQLBulkOperations |
SQLCancelHandle |
SQLColumnPrivilegesW |
SQLCompleteAsync |
SQLConnectW |
SQLCopyDesc |
SQLDescribeParam |
SQLEndTran |
SQLGetCursorNameW |
SQLGetDescFieldW |
SQLGetDescRecW |
SQLNativeSqlW |
SQLNumParams |
SQLParamData |
SQLPrepareW |
SQLProcedureColumnsW |
SQLProceduresW |
SQLPutData |
SQLSetCursorNameW |
SQLSetDescFieldW |
SQLSetDescRec |
SQLSetPos |
SQLSpecialColumnsW |
SQLStatisticsW |
SQLTablePrivilegesW |