Fail insert/select into Progress tables when above 25K recs

[peace]

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 SQL to perform a insert/select/etc on Progress tables via this setup. But the problem I get is when the Progress tables is above 25,000 records and I will then hit the following errors and would fail the same execution that works earlier.

Error Message:
“Error on input or output to a file”

Anyone have had this experience using the above setup? Could I have missed some additional settings required in any of the above components eg. Linked Server, etc. Would appreciate your advice....

 

[BCM]

There is no magical 25,000 record limit for SQL inserts and updates to tables in a Progress database. This is just a coincidence. There is something else impacting the results you are experiencing. Please provide considerably more specifics about your ODBC connection from the SQL Server to the Progress database, about the Linked Server on SQL Server, and the actual SQL statements issued.

 

[BCM]

peace -
Here is how I would update a Progress table from SQL Server via a Linked Server and ODBC:

update openquery(LinkedServerName,'select * from pub."progress-table-name" where "key-field"= 38642022 ')
set "progress-table-column1" = 100
,"progress-table-column2" = 'string-value'


This method provides the best performance. Otherwise, SQL Server must make numerous round-trips to the Progress database.

 

[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....