This content has been marked as final. Show 3 replies
OK, since I first posted this problem I have had a chance to go back and play around with flex and the wizard some more. At first I thought it might be me, not unheard of, but I have been able to connect the wizard successfully to some tables in some MySQL databases. The weird thing is that there is no rhyme or reason to why it connects. For instance I may be able to connect to a table fine, but if I try to recreate the exact connection in a new project it does not work. Also if you go in and make a change to the project, one that is working, it will break it. The only thing I can figure is that the data types in the table can cause problems. I have noticed that Flex does give me error messages for some text fields. So I am off to document the tables to see if there are any data types that may be a problem.
I wasn't able to reproduce the problem using a MySQL database. The data types that were covered and worked successfully were decimal, bigint, varchar, datetime, float, int, double, smallint, text, timestamp, and tinyint. If you have any columns with a data type other than these, please let me know.
CF QA Team
Thanks for the response. No the data types are all either int, varchar, or text, nothing fancy.
Another thought. I have the Access database and Flex builder on the same server but the MySQL databases are located on a different server. Could this be a problem?