Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Ingres > Creating a INGR...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 5826 of 5950
Post > Topic >>

Creating a INGRES linked server in SQL Server 2005

by Mani <nellaimanikandan@[EMAIL PROTECTED] > May 7, 2008 at 04:29 AM

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.




 1 Posts in Topic:
Creating a INGRES linked server in SQL Server 2005
Mani <nellaimanikandan  2008-05-07 04:29:19 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 18:41:37 CDT 2008.