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