M
Mitchell Bagley
Guest
I have an SSIS package that uses an ODBC connection to a Progress database as a source using a 32-bit ODBC driver. This package runs perfectly within the confines of BIDS. However, when I run it using the SQL Agent, it fails with the error:
The specified DSN contains an architecture mismatch between the Driver and Application.
I know that this is probably a result of it wanting a 64-bit ODBC driver for that connection, but I can't seem to get the 64-bit driver to work correctly within BIDS. Is there a trick that would allow me to use the 32-bit driver within SQL Agent and move on with my life?
Continue reading...
The specified DSN contains an architecture mismatch between the Driver and Application.
I know that this is probably a result of it wanting a 64-bit ODBC driver for that connection, but I can't seem to get the 64-bit driver to work correctly within BIDS. Is there a trick that would allow me to use the 32-bit driver within SQL Agent and move on with my life?
Continue reading...