ODBC Proxy for remotely accessing legacy resources?
- by Winston Fassett
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.