Crystal Reports 9 and MYSQL

[ICTECH]

Hi..

I've been searching the web, but haven't found much that is helpfull. I'm trying to create a Crystal Report from a MySQL table. But when I make a connection to it, there are no fields in the table. Crustal has a fix, but it doesn't work. Does anyone have any ideas?

Thanks...

 

[bueller]

IcTech,

are you attaching directly to the DB or are you going thru a DSN. It might work if you go thru a DSN instead of direct connection to the database.
HTH,
Bueller

 

[ICTECH]

Hi Bueller..

I've tried using DSN and a MySQL OLEDB Provider that I found on the MYSQL Web Site. Both gave me the same result. How do you connect to a MySQL with Crystal Reports?

 

[nomi2000]

Hi Ictech
Which version of Crystal Report you are using the have a problem with crystal report 9 with the MySQL 3.51 ODBC driver check this article

http://support.crystaldecisions.com/library/kbase/articles/c2013269.asp

But the fix only applies to crystal report 9
good luck
Regards
Nouman

Nouman Zaheer
Software Engineer
MSR

 

[ICTECH]

Hi Nomi2000...

I'm using Crystal Report 9 that comes with VB.NET. I've tried the patch that they have on there web site. But still no go.