Solved

win32::ODBC Sage Account Package issue only on Windows 7 64 bit

Posted on 2014-02-23
10
465 Views
Last Modified: 2014-04-19
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)
0
Comment
Question by:frasierphilips
  • 4
  • 4
  • 2
10 Comments
 
LVL 28

Expert Comment

by:FishMonger
ID: 39880773
Have you tried using DBD::mysql instead of DBD::ODBC?

DBD::mysql is the normal/standard module used when connecting to a mysql database.
0
 

Author Comment

by:frasierphilips
ID: 39881927
Is Sage a MySql database?  It comes with its own ODBC hosted driver
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39882544
I suspect that the DSN is not correct.

The drivers when used without creating a DSN use the default path and on this PC that could be the Demo data or something else, if you make a specific DSN it should be fine.  

The default username and password is Manager and no password if you try that with your existing setup, I expect it will return data form the demo or practice data.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39882561
P.S. V2010 is loosing support in a a couple of months as part of the Sage life-cycle policy. So upgrading to a version that is officially supported on more recent versions of windows might be a good idea.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39882574
Check it has been fully patched it should be Version 16.0.17.0158 - Help>About

Sage is NOT MySQL
0
 

Author Comment

by:frasierphilips
ID: 39882581
Nope, i'm completely certain that the settings are correct - I'm beginning to wonder if it's something to do with the fact that the version of Perl in my copy of Xampp is in some way incompatible with the Windows 7 infrastructure, particularly in the way that it's passing the username and password to the system driver.
0
 
LVL 28

Expert Comment

by:FishMonger
ID: 39882873
It's very likely that the problem is with the password hash string.

Older versions of mysql used a 16 byte hash string and newer versions use a 41 byte string.  You can enable backwards compatibility in the newer versions if you want to stay with the 16 byte password hash, but that's not the best thing to do.  You should reset the passwords so that they are using the 41 byte hashing string.  You may first need to alter the size of the password field to accommodate the longer string.

Password Hashing in MySQL
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39886347
you could try using the DSN with something else like Excel to see if it works.
0
 

Accepted Solution

by:
frasierphilips earned 0 total points
ID: 39888182
I downloaded a 3rd party ODBC connection tool and it connected perfectly
0
 

Author Closing Comment

by:frasierphilips
ID: 40010132
No answers were forthcoming and I want to close the question.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some very basic things about SQL Server filegroups.
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question