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.