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.