/me nods...
I expected that.
The place to begin is to carefully test all of the other, non-Perl applications to determine if any of them have difficulties regarding ODBC. Even if “you are sure” that it “must be” okay, and even though you may feel, “oh, that’s ridiculous, how could there be?” ... well, as I have heard it said, “Trust, but Verify.™”
The next thing to investigate is whether you have the 64-bit version of whatever driver-toolchain(s) your application is now using. (This is where you are for the first time specifically investigating this application’s technologies and interfaces.) The most likely culprit is, as I have also heard it said, “a ‘bumpy thunky’ problem.” That is to say, 64-vs.-32-bit incompatibilities. They pop up all over the place but they are centrally located and thus centrally fixed.
In any case, while you may find that you have to make some changes to an application, it is much more likely to expect that you will simply need to reconfigure and/or upgrade some specific piece(s) of middleware... drivers and such. Arguments in favor of a “Cowabunga!!” approach to a problem like this are IMHO not sustainable.
| 