Can't see synonymes tables from an ODBC client
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET
Hi! I have 2 machines M_one and M_two with Informix 5.xx. M_one has a database DB_one with 2 tables. M_two has a database DB_two with severable tables + 2 synonyme tables to the 2 tables of DB_one. There are connected using I-Net and I-Star. and everything is running fine. I can remote acces to DB_one from M_two and, DB_two from M_one. In that last case, I can see and access to all the tables of DB_two, including the 2 synonymes. However, when using I-CLI and ODBC from a Win95 client using Crystal Report, that client doesn't show the 2 synonymes created in DB_two. It can reach with no problem all the other tables in that database. Only the synonymes are missing. I looks like a priviledge problem, but it doesn't work neither if I'm logging with informix user. But maybe I lost the priviledges between M_two to M_one? One more thing : the client can directly log to DB_one and see the 2 real tables with no problem and with the same user account (in my case : informix). Does anybody knows what's wrong? Thanks, Fabrice MANSAT