18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
ACEODBC.DLL not found
thornton102
Members
I'm trying to connect to an Excel spreadsheet with this command:
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver",
"jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\\Users\\b.thornton\\Desktop\\sahi_test.xlsx", "","");
But I get this in the log:
Starting script
ERROR
exception: java.sql.SQLException: Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb), C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEODBC.DLL).
I downloaded and it installed the driver in C:\Program Files (x86)\Common Files\microsoft shared\OFFICE14. From what I've read, it should go under C:\Program Files instead. How do I fix that? I saw something about using C:\Windows\SysWOW64\odbcad32.exe.
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver",
"jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\\Users\\b.thornton\\Desktop\\sahi_test.xlsx", "","");
But I get this in the log:
Starting script
ERROR
exception: java.sql.SQLException: Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb), C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEODBC.DLL).
I downloaded and it installed the driver in C:\Program Files (x86)\Common Files\microsoft shared\OFFICE14. From what I've read, it should go under C:\Program Files instead. How do I fix that? I saw something about using C:\Windows\SysWOW64\odbcad32.exe.
Answers
On 64 bit windows, you need to download and install the 64 bit ODBC drivers, in Program Files and not Program Files (x86).
You can try following the steps on the following link.
http://sahi.co.in/w/working-with-excel-sheets
Please let me know if it solves the problem.
Regards.