title: Java 64-bit JDBC-ODBC driver issues
body: <p>I have a program that, when compiled using the 32 bit JVM works fine, but has issues if I try to use the 64 bit JVM. The message I'm getting is: <code>"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"</code>.</p>
  
  <p>I'm trying to connect to Excel and SQL Server databases using code like the following:</p>
  
  <pre><code>String file = directory + "/fileName.xlsm";
  
  String connectStr= "jdbc:odbc:DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ="  + file +  ";READONLY=false";
  
  try {
      Class.forName(getDriver());
      gConnection = DriverManager.getConnection(connectStr);
      //do stuff with connection
  }
  </code></pre>
  
  <p>When I tried to check the Driver Manager it didn't seem to have 64 bit version of the drivers. Any way to fix this easily and be able to connect using 64-bit drivers without manually changing settings on the computer (as this program will be distributed across multiple computers and I don't want to have to download a driver separately for ever computer that wants to run it)? Also, is it any more efficient to connect using 64-bit drivers, or are 32-bit ones just as good/fast (I do have very large data sets, so small differences would make a difference)?</p>