Solved

Connect Crystal Reports 2008 to mySQL database on webhost

Posted on 2010-11-09
4
670 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:stkoontz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 13

Expert Comment

by:gamarrojgq
ID: 34097702
Hi,

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

Author Comment

by:stkoontz
ID: 34101641
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
0
 
LVL 13

Accepted Solution

by:
gamarrojgq earned 500 total points
ID: 34104451
Well that is weird, have you try to create another ODBC Connection? or to create an OLE DB connection with a ConnectionString?
0
 
LVL 2

Author Comment

by:stkoontz
ID: 34104954
Using the connection string did the trick.

Thanks!

Steve
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question