Occam's Razor for 64-bit ODBC applications

Occam's Razor for 64-bit ODBC applications

November 19, 2009 0 Comments

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:

  • The application will run less efficiently and potentially more slowly due to the need to translate 32-bit application instructions back and forth between the 64-bit O/S than a 64-bit application using a 64-bit ODBC driver on a 64-bit O/S.
  • The time and effort involved in such a recompiling effort may be simple for one application but is impractical if you encounter a problem for many applications - for example if you are performing a migration.

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.

Mike Frost

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.

Comments
Comments are disabled in preview mode.
Topics
 
 
Latest Stories in
Your Inbox
Subscribe
More From Progress
d12fcc0bdb669b804e7f71198c9619a7
5 Questions Automakers Should Ask to Improve Asset Uptime
Download Whitepaper
 
SF_MQ_WCM
2018 Gartner Magic Quadrant Web Content Management (WCM)
Download Whitepaper
 
What-Serverless-Means-For-Enterprice-Apps-Kinvey
What Serverless Means for Enterprise Apps
Watch Webinar