Geek Answers Handbook

Shutting Down SQL Server Linked Server

I have a DBF file on a network share that I am trying to select in a SQL Server table.

This request:

SELECT * FROM OPENQUERY(MyLinkedServer, 'SELECT * FROM DP')

... causes this error:

The OLE DB provider "MSDASQL" for the linked server "MyLinkedServer" returned the message "[Microsoft] [ODBC Visual FoxPro Driver] Out of memory for file card.".
Msg 7399, Level 16, State 1, Line 11 The OLE DB provider "MSDASQL" for the linked server "MyLinkedServer" reported an error. The provider ran out of memory.
Msg 7320, Level 16, State 2, Line 11 Cannot execute the query "SELECT * FROM DP" against the OLE DB provider "MSDASQL" for the linked server "MyLinkedServer".

I read about using SYS (3050) to release FoxPro memory. I cannot figure out how to accomplish this against a linked server.

+5
source share
2 answers

Linked server requests use memory from an area outside the SQL Server buffer pool called memToLeave, which is used to serve connection flows, and now sql clr among others. At a 32-bit size of 384 MB, which may be inadequate for some scenarios.

If you need to configure the SQL Server memory configuration, and in particular the memToLeave realm, you will find an explanation in the following blog:

SQL Server memory configuration, memToLeave parameter definition

+4
source

SQL Server 2005 SP1 2008 , : http://support.microsoft.com/kb/974130 p >

0

More articles:


All Articles