Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server for Excel File Expand / Collapse
Author
Message
Posted Sunday, October 4, 2009 11:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:28 PM
Points: 33, Visits: 196
We are using 32 bit SQL 2K5 (Enterprise Edition) in clustered environment. For almost 1 year we are using linked server for Excel file and is working fine. Suddenly from last 2-3 days, it started giving error now even with openrowset we are not able to query Excel files.

SQL Service is having Admin privileges on the physical machine and we have tried creating linked server for files kept on local drives also but it is giving following error.


Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EXT" reported an error. The provider ran out of memory.

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "select * from [upload$]" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EXT".

Can anyone help in this..
Post #797662
Posted Monday, October 5, 2009 12:27 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, November 2, 2014 1:00 PM
Points: 368, Visits: 544
Try to check the page file settings ---- are they optimally set???
max & min memory of SQL Server.


Check the excel file if the file has some bulky data\ problem is with some specific file....... check with a simple 10rows excel file.



Regards,
Sarabpreet Singh
SQLServerGeeks.com/blogs/sarab
www.Sarabpreet.com
Twitter: @Sarab_SQLGeek
Post #797675
Posted Monday, October 5, 2009 1:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:28 PM
Points: 33, Visits: 196
Thanks for your reply. But we have tried with an excel file containing less than 100 records.

Also memory allocated to the instance is 8 GB.
Post #797687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse