Dear Sirs,
can you pls help me with this…
I have a distributed query in my SQL Server database which is run by stored procedure and it
always works good if run from query analizer…
This query refers to native SQL Server table and an Excel file presented by Linked server. If Excel file have 20 rows or so the stored procedure works OK… If 1 more row is added to Exel this error ocurrs when run from MS Access 2000 ADP-file :
“There was a problem accessing a property or method of the OLE object.” after 3 minutes of execution….
I think it is connected somehow with query execution timeout…But I checked connection properies in my adp-file and set them = 600 seconds…Why when executed in Query analyzer it’s OK and when executed under ADP-file this error ocurrs, and in case when rows in Excel file exceed some limit? What you think?