Page 1 of 1

MySQL link tool with Google Charts support available

Posted: Sun 18 Nov 2012 1:29 am
by gknopf
Hi everyone,
meanwhile I have my weather site up and running. What I created in addition is a little tool to upload every new entry of the monthly log files into a MySQL database on the web. You could also use it to embed Google Charts with your weather data into your webpage. As I have no clue about PHP it is a standalone exe file which runs on the same machine as Cumulus.

A short description is also online (http://www.blumberg-wetter.de/easycumulusdblink.htm).

Google Charts I discovered just some days ago. It looks pretty good on a weather page and is easy to implement for a newbie like me.
Image

Re: MySQL link tool with Google Charts support available

Posted: Sun 18 Nov 2012 12:45 pm
by water01
I am trying to run this on Windows 7 Pro 32bit and I get "Exception in module EasyCumulusDBlink.exe at 0028C653. Error creating object. Please verify that the Microsoft Data Access Components 2.1 (or later) have been properly installed".

As I understand it MDAC is part of W7 so why am I getting this message?

Re: MySQL link tool with Google Charts support available

Posted: Sun 18 Nov 2012 4:07 pm
by gknopf
Microsoft data access components are actually not used. Have you connected to a MySQL DB server? Other DB servers will not work. An MDAC error will appear if you try to connect to a Microsoft data source. For sure thats a different connection string.

You can check your connection if you type 'ODBC' in you Win7 start menu. Make sure you have a working connection to your weather database.
Image

Re: MySQL link tool with Google Charts support available

Posted: Mon 19 Nov 2012 6:59 pm
by water01
OK I have tested the connection using the MySQL ODBC test facility and it says I connected OK but I am still getting that error when I connect using EasyCumulusDBlink.

Re: MySQL link tool with Google Charts support available

Posted: Sat 08 Dec 2012 12:13 am
by gknopf
Obviously it is an error which occurs on some 64bit systems. On my Win7 64 bit I could not replicate it.

Win 32 systems should be definitively fine.

Re: MySQL link tool with Google Charts support available

Posted: Sat 08 Dec 2012 8:36 am
by mcrossley
Just to throw an idea in... ODBC connections come in both 64 and 32 bit 'flavours' on x64 systems, you normally have to create an 32 bit ODBC for 32 bit programs.

Re: MySQL link tool with Google Charts support available

Posted: Sat 08 Dec 2012 11:37 pm
by gknopf
You are right. Since the software is 32 bit you have to use the 32bit connector. There are just sometimes issues with 32 bit connectors on 64bit systems. With water01 I was trying to get it to work but we did not succeed. On my own Win7 64bit the 32bit connector works fine.

Let me know if you have other issues or wishes.