I need to use a 32bit ODBC DSN connection from Window 2008 64bit. I have created a DSN using C:\Windows\SysWOW64\odbcad32.exe I do not have a 64bit driver for our progress database until 6-8 months from now. (fyi if I get it now it cost us $2500, if I wait until we upgrade our ERP system then its free)
In my code I have it just like the way I connecto to DSN on a 32bit server.
public static string strODBCConn = "DSN=Nxt;UID=SYSPROGRESS;PWD=XXX;";
public DataSet FillDataSetODBC(string strSQLCmd, string strTable, String strODBCConn)
// return a filled dataset.
DataSet myDS = new DataSet();
OdbcDataAdapter DBAdapt = new OdbcDataAdapter();
//Set up the data adapter...
DBAdapt = new OdbcDataAdapter(strSQLCmd, strODBCConn);
//Fill the dataset