I recently read a blog entry where the author went to great lengths to explain what he did to make an application originally compiled as 64-bit for production deployment onto a 64-bit Windows platform work with the the 32-bit ODBC driver that he was using. My reaction, well, yeah, that's one way to solve your problem, but I'm mystified why the most obvious route to solving the problem - simply using a 64-bit ODBC driver - wasn't chosen.
There may be valid reasons which were not called out for why the author did not choose this route, but consider this:
An easier way to solve this problem would be to acquire the 64-bit version of the ODBC driver being used. Details on how to get the 64-bit version of the Progress ODBC driver for Windows is available in the Progress Knowledgebase.
Finally, it's worth noting that DataDirect offers products which can serve to connect 64-bit applications and 32-bit ODBC drivers without the need to recompile and introduce inefficiencies and performance bottlenecks. This is useful for situations when there is no 64-bit version of the ODBC driver available, which is common when one is connecting to legacy data sources or ones that are no longer being supported.
Conclusion: just like Occam's Razor suggests, the simplest solution to this problem is the best.
View all posts from Mike Frost on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.