Creating a INGRES linked server in SQL Server 2005

[Mani]

Hi,

I have created a linked server to INGRES using ODBC in SQL Server
2005. When I tried to access data from INGRES, it works well with the
OPENQUERY statement. However, when I try to use the four-part name and
create a SYNONYM in SQL server, it does not support and it throws the
following error.

Error:

My questions are:

1. Does the ODBC driver for Ingres 3.0 support four part naming
conventions ?
2. Is this the better way of accessing data from Ingres or is it
possible to create stored procedures in Ingres?

Thanks,
Mani.