I need to connect to a password protected MS Access 2003 DB using the JDBC-ODBC bridge. I can't find out how to specify the password in the connect string, or even if that is the correct method of connecting. It would probably be relevant to mention that this is a Spring App which is accessing the database through a JdbcTemplate config...
Hi, I am having a hard time establishing a connection to my database file using JDBC-ODBC bridge. The driver I am using is sun.jdbc.odbc.JdbcOdbcDriver but I believe it is not present on Mac OSX by default and hence throws an exception for class not found. I googled for the driver but could not find much useful information. Can somebod...
Hi, I've created an ODBC connection to an Excel 2007 Workbook using ACEODBC.dll, which is supposed to work for both .xls and .xlsx files. However when I try to open a connection using JDBC I get a SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. The Workbook is also password protected and encryp...
I'm dealing with an issue that has arisen for an application I've been working on which connects to a Access file via JDBC-ODBC. On other Windows platforms, this issue hasn't been encountered, but on Windows 7 64-bit boxes, attempting to connect with DSN-less connection strings return: java.sql.SQLException: [Microsoft][ODBC Driver Mana...