32-bit ODBC on Windows Server 2008 R2

Thank you, John Paul Cook!  We've been trying to figure this out for hours!

Where should I put the shortcut? I found ODBCAD32.exe in Windows\System32 too. Thanks.

AWen@Teledyne.com

Put the shortcut wherever you want. It is for your convenience.

I used C:\Windows\SysWOW64\odbcad32.exe to call XLS connection with sun.jdbc.odbc.JdbcOdbcDriver successfully.

But recently, get error:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

The registry file no changed.  

The test program is:

public class testXlsConnection{

   static String msgjdbcodbcString = "jdbc:odbc:msgsheet";

  static Connection likeXlsConnection = null;

public static void main(String[] args){

 try{

likeXlsConnection = getlikeXlsConnection();

if (likeXlsConnection == null){

  System.exit(0);

  }

try {

              likeXlsConnection.close();

            System.out.println("<<<<JDBC, ODBC Connection and files closed safely...>>>");

      } catch (Exception e) {

 System.out.println("Final error:>>>"+ e.getMessage() + "<<<\n");

      }

System.out.println("testXlsConnection Completed!!!");

      }

      catch(Exception ex){

  System.out.println("Exception in main " + ex.getMessage()+"***");

  }

}

public static Connection getlikeXlsConnection() throws ClassNotFoundException, SQLException {

   Connection likeXlsCon = null;

   try{//read data from main spreadsheet then insert records to corresponding tables

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

likeXlsCon = DriverManager.getConnection(msgjdbcodbcString);//"jdbc:odbc:msgsheet" );xlsCon;

System.out.println(msgjdbcodbcString + " Connection succesed...");

   }

   catch(ClassNotFoundException ce){

System.out.println("ClassNotFoundException for >>>" + msgjdbcodbcString + "<<<"+ ce.getMessage() );

}

catch(SQLException sqle){

System.out.println("SQLException Connection for >>>" + msgjdbcodbcString + "<<<"+ sqle.getMessage() );

}

   catch(Exception e){

System.out.println("Fail to establish Connection for >>>" + msgjdbcodbcString + "<<<"+ e.getMessage() );

}

   return likeXlsCon;

 }

}

/*from ControlPanel>>Administrator tool>>Data Source(ODBC)

Then right lick, properties box shown as:

Data Source (ODBC) properties:

Target Type: Application

Target Location: SysWOW64

Target: %windir%SysWoW64\odbcad32.exe

Start in: %windir%\SysWOW64

*/

Thanks for this info, John. I wonder why this is so hard to find at Microsoft! Much appreciated.

+1 for this answer; in our case we were using a legacy pre-.NET DLL which worked fine in WOW64, but couldn't communicate with its database until we used the WoW64 administrator.

You sir, have made my day!

Thanks a million o7

Just wanted to add, in our case, we were told we should run the 32-bit version and the one located at C:\Windows\system32\odbcad32.exe should work.

But when we tried adding a new datasource, our program could not pick up the datasource we just configured. However, there were other preconfigured ones that were not showing up in the ODBC which we thought hinted at either a config file storing previous versions or obviously running the wrong version.

When we ran the one in WOW64, all the preconfigured sources showed up and we were able to add ours and successfully use it in our program.

Thanks! Very much