Hi Marco,
Thank you for responding to my post. I'm looking for MySQL on Windows. I'm not suprised the OLEDB wouldn't work--MySQL dropped it a long time ago. I was a bit suprised that the relatively new ODBC Connector (.13 release) would not work with the PowerGadgets invoke-sql, especially since you all just added a generic ODBC connection option (at least into the PowerGadgets Creator).
I did not find your article in my search (thanks for sending it); it looks pretty straight-forward, so I'll give it a whirl (still has the look of an ASP.NET 1.1 vs. 2.0 doc) and I'll post the code/procedure if it works. Lot's of MySQL zealots out there that still love Microsoft products.
The article offered a fix off the ODBC and the ADO connector. Which has the best chance as a jumping off point for successfully working with PowerGadgets? I'll try both, if need be.
Finally, just an FYI. If you are using the PowerGadgets Creator GUI to create a map and attempt to change the colors or thresholds of the conditional values series, the designer will let you do it once and save it. The .pgf will run repeatedly, but if you attempt to modify those or any settings subsequently you will get an "index of gadget out of limits error" and the Creator will just shut off. (I can get you a screen capture if you want). It's not a critical issue for me and probably not for most, because almost all maps require drill-down and, as I understand it, you can't do drilldown using the Creator.
Thanks again!
David