MongoDB BI connector Driver DSN error - mdbodbcw.dll module not found

Working with Data Connectors & Integrations
#1

Hey Everyone,
i was trying to setup a BI connector setup for a project i’m working. i have mongosqld running locally on the windows laptop and i have downloaded and installed the odbc driver but i am unable to establish a connection. There is authentication enabled on either mongod,mongosqld processes.

bi connector version:
mongosqld.exe --version
mongosqld version: v2.14.4

odbc driver version : 1.4.1

error i get :-
driver couldnot be loaded due to system error 126: the specified module couldnot be found "MongoDB ODBC … mdbodbcw.dll in the installed location.

But i do have the mdbodbcw.dll file in the installed bin location.

image
image680×744 103 KB

#2

@Arun_guptha_1 , two thoughts:

  1. You write “mdbodbcw.dll” but the error message you pasted says “mdbodbca.dll”.
  2. Did you follow precisely the installation instructions?
#3

Yes @Jack_Woehr , i did follow the exact steps from the documentation provided.

there was typo , that’s why it didnot match the text and the error of snapshot. However i do get the mdbodbcw.dll not found when i choose Mongodb odbc unicode driver.

#4

Can you copy and paste in the terminal data that shows the error message, please?

#5

i am getting error while conneccting to the mongosqld process running in the local host from the odbc driver end. i don’t see any error messages in the terminal/cmd related to odbc. if there is a place that i can look into, please let me know, i can get those details. mongosqld process is running fine and able to map the schema to my mongo instance running in aws ec2.

#6

“connecting to the mongosqld process” from what? Does whatever application you are using do any logging? Have you checked the mongosqld logs? (I don’t know where mongosqld logs errors on Windows.)

#7

I have the tracing logs if that helps from odbc driver. I’m trying to establish a connection from mongodb odbc driver to mongosqld process.

odbcad32 2a7c-1ac4 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x0000000000000000
SQLHANDLE * 0x0000000BBDF8AB30

odbcad32 2a7c-1ac4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x0000000000000000
SQLHANDLE * 0x0000000BBDF8AB30 ( 0x000001331ABF6C50)

odbcad32 2a7c-1ac4 ENTER SQLSetEnvAttr
SQLHENV 0x000001331ABF6C50
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER 0

odbcad32 2a7c-1ac4 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x000001331ABF6C50
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER 0

odbcad32 2a7c-1ac4 ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABF6C50
SQLHANDLE * 0x0000000BBDF8AB28

odbcad32 2a7c-1ac4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABF6C50
SQLHANDLE * 0x0000000BBDF8AB28 ( 0x000001331ABFA0B0)

odbcad32 2a7c-1ac4 ENTER SQLDriverConnectW
HDBC 0x000001331ABFA0B0
HWND 0x0000000000000000
WCHAR * 0x00007FFCBAEA7210 [ -3] “******\ 0”
SWORD -3
WCHAR * 0x00007FFCBAEA7210
SWORD -3
SWORD * 0x0000000000000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

odbcad32 2a7c-1ac4 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x000001331ABFA0B0
HWND 0x0000000000000000
WCHAR * 0x00007FFCBAEA7210 [ -3] “******\ 0”
SWORD -3
WCHAR * 0x00007FFCBAEA7210
SWORD -3
SWORD * 0x0000000000000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

	DIAG [IM003] Specified driver could not be loaded due to system error  126: The specified module could not be found. (MongoDB ODBC 1.4.2 ANSI Driver, C:\Program Files\MongoDB\ODBC\1.4\bin\mdbodbca.dll). (160)

odbcad32 2a7c-1ac4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 1
SQLWCHAR * 0x0000000BBDF89E28
SQLINTEGER * 0x0000000BBDF89E24
SQLWCHAR * 0x0000000BBDF89E40
SQLSMALLINT 512
SQLSMALLINT * 0x0000000BBDF89E20

odbcad32 2a7c-1ac4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 1
SQLWCHAR * 0x0000000BBDF89E28 [ 5] “IM003”
SQLINTEGER * 0x0000000BBDF89E24 (160)
SQLWCHAR * 0x0000000BBDF89E40 [ 189] “Specified driver could not be loaded due to system error 126: The specified module could not be found. (MongoDB ODBC 1.4.2 ANSI Driver, C:\Program Files\MongoDB\ODBC\1.4\bin\mdbodbca.dll).”
SQLSMALLINT 512
SQLSMALLINT * 0x0000000BBDF89E20 (189)

odbcad32 2a7c-1ac4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 2
SQLWCHAR * 0x0000000BBDF89E28
SQLINTEGER * 0x0000000BBDF89E24
SQLWCHAR * 0x0000000BBDF89E40
SQLSMALLINT 512
SQLSMALLINT * 0x0000000BBDF89E20

odbcad32 2a7c-1ac4 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 2
SQLWCHAR * 0x0000000BBDF89E28
SQLINTEGER * 0x0000000BBDF89E24
SQLWCHAR * 0x0000000BBDF89E40
SQLSMALLINT 512
SQLSMALLINT * 0x0000000BBDF89E20

odbcad32 2a7c-1ac4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 1
SQLWCHAR * 0x0000000BBDF8AB40
SQLINTEGER * 0x0000000BBDF8AB38
SQLWCHAR * 0x00000133381522E0
SQLSMALLINT 494
SQLSMALLINT * 0x0000000BBDF8AB20

odbcad32 2a7c-1ac4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0
SQLSMALLINT 1
SQLWCHAR * 0x0000000BBDF8AB40 [ 5] “IM003”
SQLINTEGER * 0x0000000BBDF8AB38 (160)
SQLWCHAR * 0x00000133381522E0 [ 189] “Specified driver could not be loaded due to system error 126: The specified module could not be found. (MongoDB ODBC 1.4.2 ANSI Driver, C:\Program Files\MongoDB\ODBC\1.4\bin\mdbodbca.dll).”
SQLSMALLINT 494
SQLSMALLINT * 0x0000000BBDF8AB20 (189)

odbcad32 2a7c-1ac4 ENTER SQLDisconnect
HDBC 0x000001331ABFA0B0

odbcad32 2a7c-1ac4 EXIT SQLDisconnect with return code -1 (SQL_ERROR)
HDBC 0x000001331ABFA0B0

	DIAG [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)

odbcad32 2a7c-1ac4 ENTER SQLFreeHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0

odbcad32 2a7c-1ac4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x000001331ABFA0B0

odbcad32 2a7c-1ac4 ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x000001331ABF6C50

odbcad32 2a7c-1ac4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x000001331ABF6C50

#8

Well, it’s pretty clear why the program is unhappy … it can’t load that .dll.
Why not?
You say it is present in the directory.
Have you looked at the permissions on the .dll file?
Have you checked to see that the .dll is not somehow damaged, e.g., did it become a zero-length file somehow?
Etc.

#9

Yes @Jack_Woehr , file do exist with data(size is non zero bytes definitely) . permissions are open as well on the file. tried to change the path from default installation place to a different location re-installed with different location. still same error.

#10

Hmm that makes no sense at all :wink:
Someone from MongoDB staff will have to help you.
@Stennie ?