>>>>> "Federico" == Federico Sevilla <jijo@stripped> writes:
Federico> If I open the link to my jobs database first, attempts to open the
Federico> accounts/contacts database during the session will render an "ODBC
Federico> call--failed". If I open the link to the accounts/contacts database first,
Federico> then attempts during the same session to open the table(s) from the jobs
Federico> database will fail with the same error.
Federico> Further details of the error:
Federico> - I get a second prompt which reads: "[TCX][MyODBC]Table
Federico> 'contactmgr.test_oc' doesn't exist(#1146)". It looks like it's trying to
Federico> access the table I want from the first database which I opened, which in
Federico> this case is wrong.
The above should work.
Which MySQL version are you using? Are you sure that the test_oc
exists in the contactmgr database?
Check also that you haven't checked the following option in the MyODBC
Ignore # in #.table
If you can't get this to work, try checking the MySQL log files and
to find out exactly what's happening.