Recent content by peace

Thanks a lot on the suggested openquery method - got the insert and select working fine with good response but had some problem w/ the update. Shall try your suggested update method again tomorrow and see what happen - hopefully it works....:)

I am using the Linked Server from MS SQL 2000 to connect the Progress 9.1D (SQL92) via the Merant 3.6 ODBC Driver. I am able to retrieve all the tables and fields from the mentioned Progress database by using the SQL Query Analyzer, and able to run sql statement stored in stored procedures in MS...