Problems using synonyms in Oracle with ODBC

We have a problem connecting a Visual Basic application to an Oracle database using ODBC:

We are unable to connect to tables names which are represented by public synonyms in the Oracle DB. For example, the following statement will fail:

select * from hem_users;

where hem_users is a public synonym in the Oracle DB. The error message is "coudn't find table or object handelmasys.hem_users" where handelmasys is the owner of the table which the hem_users public synonym refers to.

Any suggestions/ideas?

Thanks,
Jens R., OECD Halden Reactor Project Received on Sun May 21 1995 - 00:00:00 CEST