Ran into an issue with 64 bit windows and Sage Line 50. We use excel to suck data from sage for our stock, accounts, etc… All of the spreadsheets that we have rely on the ODBC connector but it wouldn’t work, even when we tried to configure it via the 32 ODBC control panel applet. I had another look at it today and a little Google later I found this link.
Here’s what I got from it. Browse to the C:\Windows\syswow64 folder and run odbcad32.exe, you should now be able to configure the path to your sage data ase before. This basically fixed the issue, seems to me that Microsoft have some more work do to.
I belive that this is only an issue with Windows 7 64 bit. I have installed Windows 7 (64 bit) clean and then installed Sage on top of the clean Windows 7, then Excel 2010 (it was Excel 2007 when I first had the issue) and it worked frist time so if you having issues, a bit drastic but maybe a format reinstall will work. If you go down the reinstall route ensure that you have a fully tested backup.
UPDATE (16/07/2010):
Put the insturctions for the fix on this post, to save a click.
Would you like a video demo? If so then please leave a comment telling me so, if I receive enough then I, i’ll do it.
Loading tweets...
5 comments
1 ping
redware
July 4, 2010 at 8:38 pm (UTC 0)
I tried this but still no joy for me using Sage 50 ODBC on Windows 7 64 bit.
Wayne
July 4, 2010 at 9:31 pm (UTC 0)
If it a clean install of Sage? What version of sage? What version of excel?
Paul Nicholson
September 29, 2011 at 10:53 am (UTC 0)
You are my hero!!
Thank god for that!!!
Gareth
November 23, 2011 at 10:51 am (UTC 0)
Saved my life!!! Thank you
Flash
January 4, 2012 at 11:03 pm (UTC 0)
In the UK you have sweets with holes in the middle called Polo. In NZ, we have the same sweet, but they are called Lifesavers. I guess they are so-named because they resemble the buoyancy aids found on ships and piers. Now, I doubt you are shaped round or have a hole in the middle, but you are a lifesaver. Thank you infinity.
Tweets that mention New blog post: - Sage Line 50 and Windows 7 64bit -- Topsy.com
May 11, 2010 at 4:22 pm (UTC 0)
[...] This post was mentioned on Twitter by Wayne T Taylor. Wayne T Taylor said: New blog post: http://tinyurl.com/3a6eapc – Sage Line 50 and Windows 7 64bit [...]