Link to home
Start Free TrialLog in
Avatar of stkoontz
stkoontzFlag for United States of America

asked on

Connect Crystal Reports 2008 to mySQL database on webhost

I'm developing an application in PHP that using a mySQL database stored on our webhost.  How do I get Crystal Reports 2008 to connect to the mySQL database?  I don't see an option in the database wizard for a mySQL database.

Thanks in advance for any help.

Steve
Avatar of gamarrojgq
gamarrojgq

Hi,

You can try using ODBC or Ole DB, where you can use your own connection string, like in the attached image
MySqlCrystal.jpg
Avatar of stkoontz

ASKER

Thanks for helping me with this.

I set up an ODBC connection to the mySQL database that tested fine.  When I select that connection in Crystal, no tables come up.

The funny thing now is that when I try to go back in to edit or delete that ODBC connection, I get the error "invalid input string."

Thanks again.  I do appreciate the help.

Steve
odbc.jpg
ASKER CERTIFIED SOLUTION
Avatar of gamarrojgq
gamarrojgq

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Using the connection string did the trick.

Thanks!

Steve