Connecting to SAGE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franc sutherland - 15 May 2008 15:55 GMT

Hi,

I am trying to build a database in Access 2003 which can connect to
information in a SAGE system. Should I use ODBC, and if so, which
driver is required? Is there another way of connecting? Which is
best?

Thanks,

Franc.

Reply to this Message

timmg - 15 May 2008 19:03 GMT

On May 15, 9:55 am, franc sutherland <franc.sutherl...@googlemail.com>
wrote:

> Hi,
>
> I am trying to build a database in Access 2003 which can connect to
> information in a SAGE system. Should I use ODBC, and if so, which
> driver is required? Is there another way of connecting? Which is
> best?

Which Sage? I've had sucess connecting to the Sage Fundraising
products via ODBC. I think they lock down access to read only, but it
was sufficient for the queries I needed to run. Interesting data
model.

I never had the need to connect directly to Peachtree - it's import
export automation is quite sophisticated.

Tim Mills-Groninger

Reply to this Message

franc sutherland - 15 May 2008 19:29 GMT

> On May 15, 9:55 am, franc sutherland <franc.sutherl...@googlemail.com>
> wrote:
[quoted text clipped - 15 lines]
>
> Tim Mills-Groninger

Hi Tim,

Thanks for your reply. It's a basic SAGE account package like Line 50
or Quick Accounts (or something like that).

Where did you get the ODBC drivers from?

Thanks,

Franc.

Reply to this Message