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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.