I have a potential need to do some reporting from data that exists in a mySQL database.

I was wondering if anyone has used SGSV to look into such a database. If so, I'd appreciate any trick, tips or suggestions.

Joe,

I used the OLEDB provider from Cherry City Software and used the following connection string:

Provider=OleMySql.MySqlSource; Data Source=localhost; User ID =root; Password=oshawa; Initial Catalog=World;Activation=S4YG-88AJ-J8JA-MSLQ;

The provider requires an activation code - the one provided here is the free one and it will expire after May 15, 2010. A permament code is available for $9.99.

I tried to use the ODBC driver, but had no luck, but the Cherry City OLEDB provider works ... took just a fee minutes to get it going.

If you have a OLEDB provider, then you won't need this one. I do not use MySql so I am not sure if they provide one.

Paul.