Page 1 of 1

ODBC and MySQL Data sources

Posted: 26 Sep 2013, 16:14
by billshankley
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?

Re: ODBC and MySQL Data sources

Posted: 27 Sep 2013, 09:05
by brucedenney
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)

Re: ODBC and MySQL Data sources

Posted: 30 Sep 2013, 12:40
by billshankley
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...

Re: ODBC and MySQL Data sources

Posted: 30 Sep 2013, 14:19
by brucedenney
I can not be understanding the question.

Re: ODBC and MySQL Data sources

Posted: 30 Sep 2013, 14:35
by billshankley
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.

Re: ODBC and MySQL Data sources

Posted: 01 Oct 2013, 15:58
by brucedenney
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.