?
Solved

Connect Crystal Reports 2008 to mySQL database on webhost

Posted on 2010-11-09
4
Medium Priority
?
678 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 2000 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

801 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