Real Basic with large mySQL databases

I'm trying to develop an application in realBasic for a customer who's using OSCommerce with MySQL.
The database contains around 100 tables.
Using both the ODBC and the MySQL plugin I can create the Data source but it just opens a blank window and freezes.
This problem may be related with the large number of tables in the database, because when I do the the same thing with databases with few tables everything seems to work correctly.
poemorellaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bernard S.CTOCommented:
Your data source is just one or several connections do your db, there are no reasons why you should keep "lots of" tables open.
So the problem might be something else.

Maybe the SQL queries you are building are the source of the problem.
I would suggest:
1 - That you install phpMyAdmin if not yet available.
2 - That you display the text of the queries before running them, and that you directly check in phpmyadmin if they return the expected result. If you still get a blank page without the texte of the query that should display... place a php   exit(); just after the display of the text. This will of course stop your program.... but you will have the text of the query and will be able to test it.
Place here a copy of the error messages (after cleaning any server name etc)

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bernard S.CTOCommented:
B-) Glad it helped. thx for the grade and points
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.