SAGE 50 Accounts and QlikView

[#1]

Has anyone managed to link SAGE 50 accounts to qlikview via SQL 2005? The tables in SAGE are DTA files, I am struggling to bring SAGE through via ODBC link.  Any help would be appreciated, Mandy

[#2]

Hi Mandy,

Your post was very useful to me, I've established connections to sage and am loading the data after following your driver advice.  I was wondering if you are able to share any information on key data tables, schema and join fields?

Thanks

[#3]

hello Mandy,

can you share your dashboard, we have sage 50 and want to learn as much as we can about this?  We started a dashboard, but need to get correct ideas and table links, let me know if thats possible

[Qik]

Hi Mike,

I'm having a similar problem and receive the following error when trying to connect Qlikview with Sage 50 ODBC back-up files.

Connector connect error: SQL##f - SqlState: HY000, ErrorCode: 2003, ErrorMsg: [MySQL][ODBC 5.2(a) Driver]Can't connect to MySQL server on 'localhost' (10061)
ODBC CONNECT32 TO ***

Appreciate any guidance on the route cause and how to resolve this error.

Regards

Paul
Regards