Christopher Chitemerere (Customer) asked a question.
Power BI ODBC Driver for Salesforce
I have just installed the ODBC for Power BI to connect to Salesforce and I am getting the following error message after my SOQL statement:
Details: "ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (DataDirect 8.0 Salesforce, C:\Program Files\Progress\DataDirect\ODBC\drivers\ddsfrc28.dll)."
Kindly assist.
Regards,
Chri
Hi Chri,
IF you are able to connect using other toools like ODBCTest, WinSQL but not with Power BI then the possible cause could be that the PowerBI tool is not able to locate the jvm.dll.
To resolve this issue please copy jvm.dll to the <installation Path>\drivers directory. You will find this library in <installation Path>\jre\bin\server directory.
https://community.progress.com/s/article/system-error-126-when-attempting-to-connect-using-autorest-odbc-driver
This is other knowledge base article with few other reasons for this error and possible resolutions.
https://community.progress.com/s/article/000032614
Hope this helps.
Thank you very much for your response below, much appreciated.
I followed your instructions below and downloaded the dll file and put it in the appropriate driver directory and I am still getting the same error message.
Kind regards,
Chris
Hi Chris,
That's not good to hear.
Did you also have a chance to check the possible causes mentioned in another KB article and try those resolutions?
https://community.progress.com/s/article/000032614
If yes, then you probably need to open a support case to get this situation investigated in more deeply.