Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

MySQL link tool with Google Charts support available

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
gknopf
Posts: 6
Joined: Mon 15 Oct 2012 8:11 pm
Weather Station: PCE FWS 20 attached to EeePC
Operating System: WinXP
Location: Munich, Germany
Contact:

MySQL link tool with Google Charts support available

Post 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
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:

Re: MySQL link tool with Google Charts support available

Post 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?
David
Image
gknopf
Posts: 6
Joined: Mon 15 Oct 2012 8:11 pm
Weather Station: PCE FWS 20 attached to EeePC
Operating System: WinXP
Location: Munich, Germany
Contact:

Re: MySQL link tool with Google Charts support available

Post 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
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:

Re: MySQL link tool with Google Charts support available

Post 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.
David
Image
gknopf
Posts: 6
Joined: Mon 15 Oct 2012 8:11 pm
Weather Station: PCE FWS 20 attached to EeePC
Operating System: WinXP
Location: Munich, Germany
Contact:

Re: MySQL link tool with Google Charts support available

Post 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.
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: MySQL link tool with Google Charts support available

Post 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.
gknopf
Posts: 6
Joined: Mon 15 Oct 2012 8:11 pm
Weather Station: PCE FWS 20 attached to EeePC
Operating System: WinXP
Location: Munich, Germany
Contact:

Re: MySQL link tool with Google Charts support available

Post 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.
Post Reply