General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
distributed query based on SQLServer DB and Excel sheet returns error ...
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?