Creating Trigger in MSSQL Linked Server connected to Progress

I

irina_walker

New Member
Hi,
I have connected MS SQL Server linked server to Progress database and am trying to create a trigger that would fire if a record was inserted into Progress db inserting a record into a table in MSSQL db.

I'm using Query Analyzer, and can select anything from Progress db by using OPENQUERY syntax, so I can specify a name of Linked server. If I try to use for a table name a combination LinkedServerName.SchemaName.TableName, it won't recognize an object.

Did anybody try to do it? What do I need to use to be able to identify a table in Linked Server?
Thank you,
Irina
 
Irena,
I've been unsuccessful in attempting to create a linked server, as you say you have done. I would greatly appreciate any assistance you would provide to point the way!
I have created a datasource that connects with the Test button, and named that datasource in the linked server setup. I also specifed the same user/pw fro remote logins on the security tab in the linked server setup. I am using MSDASQL as the connection string (not sure if this is correct).
When I attempt to display tables (in Enterprise Manager) I get Error 7739: OLE DB Provider MSDASQL ... IDBInitialize ... returned 0x80004005.

Thanks,
Ken
 
You must log in or register to reply here.
Back
Top