Jump to content
Sign in to follow this  
carl9861

MySQL view crashes FP12

Recommended Posts

As a newbie to MySQL and EDS techniques, I have set up MySQL locally on my PC and am able to see the x4 tables and the x1 view that I have created via an ODBC data source in FP12. My problem is that I can bring in the tables into the relationship graph, but when I try to bring in the view (which includes 38,000 rows) FP12 crashes.

The view appears to perform normally in the Command Line Interface.

Am I doing something wrong? A quick relply would be very much appreciated.

Share this post


Link to post
Share on other sites

Does it officially crash where you get an error message or does it just seem like it is stuck? If it is the latter then try and wait it our for a while. I have had similar experiences when connecting to Oracle where it take forever to do anything in the graph. Needless to say all my ESS shadow tables are now in a dedicated fm file.

Share this post


Link to post
Share on other sites

Sadly, it's the former. As soon as I select the view from the dropdown I get the dialog 'Filemaker Pro Advanced has stopped working'.

The software is running on the latest version (e.g. 12.0v2).

Any further suggestions?

Share this post


Link to post
Share on other sites

Have you tried a new file? Also do you have access to modify the view and put a limit on it?

Share this post


Link to post
Share on other sites

I have since discovered this topic http://forums.filemaker.com/posts/3563eb5bb3 which highlights the need for the MySQL Connector/ODBC 5.2 alpha driver. I've installed the driver and can confirm that it appears to have solved the problem as I can now bring all views and tables into FP12.

Thanks for the replies.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    john9210 
×

Important Information

By using this site, you agree to our Terms of Use.