Solved

Connect Crystal Reports 2008 to mySQL database on webhost

Posted on 2010-11-09
4
663 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
  • 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
VB.Net - For Loop Error 5 26
Create XML 5 34
Saveas need to save a copy 16 11
Help with a Crystal Report Formula - remove time 5 10
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now