It should work for you. Its not a limitation with FM10. There must be something else at bay here.
<!-- StartFragment -->It can see the tables and can select the tables in the SQL Builder, but when select the table nothing show in the columns.
No error no massage, just can not see the contents in the columns box.
But if do the same things in FM5.5, we can see the data in “Tables” and “Columns”.
All set up is the same, because FM5.5 and FM10 are in same computer.
Please please someone help?
Thanks.<!-- EndFragment -->
Are you using the same EXACT account for both FM5 and FM10 ODBC connections?
Yes, same PW and ID for ODBC data source, Select ODBC Driver, User nameand password, then SQL Query Builder come up and can select the any Tables, but not able to see columns.<!-- EndFragment -->
Try this... See if you can create an ESS connection directly to it. I am going to assume that you know how to do this already...
If you can not connect with the ESS directly, then you may want to try reinstalling FMP10.
Thank you very much for help.
What ESS connection means?
I know File maker SQL connection but I do not know ESS connection.
Could you explain how to do?
SQL Query builder, FM10 and FM5.5 use same program?? In this computer FM5.5 and FM10 both software are installed.
Do they use same "SQL Query builder" program in the Filemaker when connect to ODBC data?
If same one, FM5.5 is working OK, but not FM10.
Yes, ESS is the one I am doing.
I am accessing data to External SQL data sources from this computer.
FM5.5 OK, but not FM10.
Now I have found something.<!-- StartFragment -->
I cannot see the contentsin the columns from SQL Builder, but I can import if I wrote specify query using text.
But I cannot use QueryBuilder.
No you are not. ESS is new since FM9. There is a difference between ODBC import verses ESS.
My suggestion is to either reinstall or try install on another computer.