Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

ODBC and MySQL Data sources

Report design issues and solutions.
Post Reply
billshankley
User
User
Posts: 39
Joined: 30 Sep 2009, 12:55
Sage Version: v2015 21 UK/Europe/Africa

ODBC and MySQL Data sources

Post by billshankley » 26 Sep 2013, 16:14

I'm looking at setting up a datasource in the Sage Report Designer to a MySQL database on our network, the option to add new datasources is available, MySQL even happens to be one of them but neither that or using a ODBC system DSN appears to work with standard connection strings.

Has anyone got some example connection strings or experience of setting this up?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: ODBC and MySQL Data sources

Post by brucedenney » 27 Sep 2013, 09:05

Here you are...

ConnectionString = "ODBC;DSN=SageLine50v" & DN & ";UID=" & UR & ";PWD=" & PW & ";DIR=" & DR & ";"

DN is the version of Sage 50
UR is the user name eg MANAGER
PW is the Password
DR is the path to the Sagea (it should end with \ACCDATA.. eg C:\SageData\2012\DemoData\ACCDATA)
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

billshankley
User
User
Posts: 39
Joined: 30 Sep 2009, 12:55
Sage Version: v2015 21 UK/Europe/Africa

Re: ODBC and MySQL Data sources

Post by billshankley » 30 Sep 2013, 12:40

Hi Bruce,

Thanks, my question though was specifically linking to MySQL, I can link to other Sage installs using your connection string and to SQL server instances with the following connection string

Server=myServer\sqlInstance;Database=myDb;User Id=sa;

But I simply cannot get MySQLDataProvider or ODBCDataProvider (found in tools/data sources/add/data provider) to play ball...

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: ODBC and MySQL Data sources

Post by brucedenney » 30 Sep 2013, 14:19

I can not be understanding the question.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

billshankley
User
User
Posts: 39
Joined: 30 Sep 2009, 12:55
Sage Version: v2015 21 UK/Europe/Africa

Re: ODBC and MySQL Data sources

Post by billshankley » 30 Sep 2013, 14:35

I'm in Report Designer and adding a datasource, your connection string appears to be an example for connecting to a sage install but I want to connect to non Sage MySQL database either directly or via ODBC and then pull that data on to my report via a subreport.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: ODBC and MySQL Data sources

Post by brucedenney » 01 Oct 2013, 15:58

If you are trying to use the Sage report designer to report on data that is not coming from sage you are unlikely to get anywhere as I think it is tied to Sage.

You would need to buy an independent report designer not one that is tied to Sage products eg Crystal Reports, use MS Access/MS Excel or something like that.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests