Linked Servers for Ingres and SQLServer
Posted on 2003-12-09
I'm currently trying to link a remote server using Ingres to a local server using SQLServer. For the local SQLServer, I'm using the free desktop version available on the Microsoft website. Therefore I'm using osql.exe in command prompt... The following is the command I'm using with osql in command prompt:
osql -E -S localhost -d master -i server.sql
where master is the name of the database on the local server (SQLServer), and the following is the code in server.sql:
@server = 'FISH',
@srvproduct = 'ingres',
@provider = 'MSDASQL',
@datasrc = 'fish'
The problem I have is when I run the above commands, I get: "1> 2> 1> 2> 3> 4> 5> 6> (1 row affected) (1 row affected)" BUT when I run the following trigger:
CREATE TRIGGER op_trig
INSERT INTO FISH.operation (code, name, etc etc)
SELECT code, name, etc etc
DELETE FROM op_temp
where op_temp is a table on the local server and operation is a table on the remote server,I get an error: "Invalid object name 'cefish.operation'"?!?!?!?!? What am I doing wrong?