MSDASQL for linked server MYSQLDB Error Issue

Geeth Janarthanan
Geeth Janarthanan used Ask the Experts™
on
Hi ,

Please Give me Solution for my Below Issue,

Got Issue like The OLE DB provider "MSDASQL" for linked server "MYSQLDB" reported an error. The provider ran out of memory.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> The provider ran out of memory.

Check whether you have sufficient memory available in your Server and either increase more RAM to the Server or configure the Max Server Memory to get sufficient space for OS and other operations.
Also try to see whether you have sufficient memory available in your server by following this article once..
https://www.johnsansom.com/sql-server-memory-configuration-determining-memtoleave-settings/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today