Search This Blog

Tuesday, July 17, 2012

The provider ran out of memory

Error:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider ran out of memory.

Cause:
This error comes when we execute the following code and sql instance has been expired.

Query
SELECT * INTO #tmp
FROM
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=\\198.1.110.15\d$\Inetpub\wwwroot\WebSite2\FutureKPA\EmpProductivity.xls;Extended Properties=''Excel 8.0;HDR=Yes''')...[Sheet1$]

Solution:
Relogin to SQL Server.