I am trying to add an external data source so that our Epicor 10.2 can run queries against our legacy Vantage 5.2 on Progress 9.1D. I am able to install the Merant 32 bit ODBC driver for Progress on our Epicor 10.2 server. I am able to launch ODBC (32 bit) and successfully connect to and authenticate with this DSN. But when I go to my external data source in Epicor 10.2 and enter this DSN and all its settings, I get this error:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application(0)
If I had to guess, Epicor is trying to use ODBC 64 bit instead of ODBC 32 bit where the DSN is configured, probably because this is a 64 bit version of Windows. But I double-checked the bitness of all of the Epicor applications and they are all 32 bit, not 64 bit, so I would think they would call ODBC 32 bit. This doesn’t seem to be happening.
There is no way to install a 32 bit version of Server 2016. Is there perhaps a 64 bit version of an ODBC client that can connect to Progress 9.1D? From what I have read Progress did not create one, but does anyone know of any third party one that might exist?
I’m assuming you won’t be using your legacy Vantage/Progress database any more? As much as a hassle it is I would be inclined to make a datawarehouse out of the data and store it in SQL.
In order to get the data over you could use an earlier version of SQL that supports 32bit odbc and create a linked server, or and some of the more experienced Progress people on E10 may even suggest a dump of the data and import it that way as a one off…Coming to think about it doesn’t the upgrade process do that? I have never had a need to do it so I am not 100% sure.
I found this article on the progress database, but by the sounds of it you may need upgrade your progress version to get the functionality, but as I mentioned earlier someone has probably run into this issue before and could provide some real life experience.
A coworker and myself were recently looking into a 64-bit Progress ODBC and found that a full official release doesn’t exist. But, there is a trial version of the software (15 day period?) that is available in 64-Bit as opposed to the Full Versions 32-Bit version. I believe a non-trial version of the 64-Bit was never released due to possible software instability problems or something along those lines, but it seemed to work for us during the trial period. Below I have linked the location where we downloaded the software if you want to look into it further.
It creates an ODBC server on the Progress host which connects to the local ODBC DSNs configured on the Progress Server. You can sort of think of it like a “remote desktop for ODBC”. Then on my Epicor server I set up an ODBC connection back to this bridge, and now Epicor 10 can connect without errors.