ODBC Proxy for remotely accessing legacy resources?
Posted
by Winston Fassett
on Stack Overflow
See other posts from Stack Overflow
or by Winston Fassett
Published on 2010-01-13T21:20:45Z
Indexed on
2010/03/12
9:07 UTC
Read the original article
Hit count: 421
Our project uses AcuCorp's AcuODBC driver to access a legacy Vision database. The problem is that we only have a 32-bit driver and the installer simply won't run on our 64-bit servers. I need a way to use SSIS to pull data from that system. As far as I can tell, there are 3 options:
- Set up a whole new SQL Server instance with SSIS and the AcuODBC drivers on a 32-bit VM (costly)
- Try to hack the 32-bit driver onto our 64-bit server manually (failure prone and unsupported)
- Set up a 32-bit VM with some sort of "proxy" service that our 64-bit SSIS can use to pull the data.
The first option is the least desirable. If you have any suggestions for options 2 or 3, or anything else I haven't thought of, I'd love to hear them.
© Stack Overflow or respective owner
