stkoontz
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
Thanks in advance for any help.
Steve
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Using the connection string did the trick.
Thanks!
Steve
Thanks!
Steve
You can try using ODBC or Ole DB, where you can use your own connection string, like in the attached image
MySqlCrystal.jpg