x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 56 subscribers
  • Views 953 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
177
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
175
topics
311
replies
Install your software
138
topics
375
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
147
topics
321
replies
Protect and repair your data
44
topics
136
replies
Run your accounts remotely
85
topics
197
replies
Working with the bank
114
topics
292
replies
BDLJEFF

Upgrade Sage version - ODBC Compatibility

SOLVED
Posted By

We need to upgrade one off our clients to Sage 50 v25 from v23.  However, their Access database has ODBC links to the current version.  Does anybody here know about the ODBC connector?  Specifically, when we upgrade, will the ODBC links still work, or does the upgrade have the potential to break?  In other words, is the v25 Sage ODBC driver backward compatible?

I've tried contacting Sage Office support but have not had any response after a few days.

Thanks.

  • +1
    verified answer

    Hi,

    Thanks for using Sage City.

    When you upgrade from v23 to v25 you'll get the new ODBC driver, it'ls likely that whatever you were using ODBC with will need point to the v25 source rather than v23.

    We haven't actively removed any tables from ODBC so what was readable previously in v23 should still be available in v25.

    Further information on ODBC can be found here

    If this has answered your question please click More > Verify Answer.


    Regards,

    Ian

    Sage UKI

  • 0 in reply to Ian C

    Thanks Ian, that's great.  I also just discovered that the Access database uses SDO to post transaction data to Sage.  Will the programming code for that be compatible too, or might it need a rewrite?  We are not Sage developers so not sure of the best approach.

  • 0 in reply to BDLJEFF

    SDO is slightly different to ODBC with it being able to post to Sage 50. Again we haven't removed any functionality from SDO but you may need to reconfigure access again to use it. With it being Access this should be fairly straight forward but we don't offer support around this, you may need to reach out to whoever set it up originally. 

*Community Hub is the new name for Sage City