Solved

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

Posted on 2014-02-23
10
457 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
 
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now