win32::ODBC Sage Account Package issue only on Windows 7 64 bit
Posted on 2014-02-23
My client has just upgraded all their PCs to Windows 7 64 bit. The file sharing machine is running a booking system, accessed via a web browser, using Xampp, MySQL and Activestate Perl.
Also on the file server, is a folder containing the data files for their Sage Accounts 2010 accounting package. These systems have run for many years under XP Pro 32 bit however when the booking system has been transferred to Windows 7 64 Bit, an anomaly has arisen (everything else works perfectly)
The booking software establishes read-only access to the Sage database via the Sage 32 Bit ODBC driver in order to download financial information for the purposes of calculating commissions.
I installed Sage on the file sharing machine and changed the ODBC data source (using syswow64/odbcad32.exe) to the correct folder- I've checked that the software can see the driver (it can) however when I try to invoke the connection I get an invalid username/password error (I know both un/pw are correct).
I have also tried to connect via DBD/DBI and get the same result, the exact error message being:-
User ID or Password invalid (SQL-28000) [state was 28000 now 01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00 (SQL-01000) [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). (SQL-01000)