Home Services Partners Company
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.

Read next SAS ODBC Access to Salesforce, SQL Server and Marketo
Comments
Comments are disabled in preview mode.