PDA

Click to See Complete Forum and Search --> : Crystal Reports connection to a Bugzilla MySQL database - problem with links.

JamesMitchell
November 17th, 2006, 10:20 AM
I'm trying to set up Crystal Reports with an ODBC connection to Bugzilla which I know works.

It is crashing if I add more than one table - either if I click on Links or OK.

Do I need to give the user any extra priveledges to see links between tables. Are there links between tables in the MySQL database in the same way you would see in a SQL Server database?

I've done searches such as:
bugzilla odbc links
and
mysql odbc links

but I didn't find anything...

Thanks for your help,

James
JamesMitchell
November 24th, 2006, 06:37 AM
Nobody got any idea what I might be doing wrong? My MySQL server is on a Linux Fedora Core 5 machine if that helps...
JaganEllis
November 26th, 2006, 05:01 PM
It could be smart linking.
Try 'File' menu, 'Options', 'Database' tab, uncheck 'Automatic Smart Linking' at the bottom of the 'Advanced Options' section.
JamesMitchell
December 4th, 2006, 10:25 AM
It could be smart linking.
Try 'File' menu, 'Options', 'Database' tab, uncheck 'Automatic Smart Linking' at the bottom of the 'Advanced Options' section.
I don't have an 'Automatic Smart Linking' option, I'm using Crystal Reports 9.2.0.448