locked
mysql client ran out of memory RRS feed

  • Question

  • hi all

    when i create linkserver from sql server to mysql. i used select command 

    select * from openquery([ipserver], 'select * from db.tablename')

    and i got an error 

    The OLE DB provider "MSDASQL" for linked server "Ipserver " reported an error. The provider ran out of memory.
    Msg 7330, Level 16, State 2, Line 1
    Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "Ipserver ".

    any one can help me ?

    Thursday, December 13, 2012 4:23 AM

Answers

  • How about

    select * from openquery([ipserver], 'select top 1000 * from db.tablename')

    Also, perhaps you can specify column names you want to select from that table name?


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    • Proposed as answer by Kalman Toth Thursday, December 13, 2012 5:16 AM
    • Marked as answer by Kalman Toth Thursday, December 27, 2012 10:46 PM
    Thursday, December 13, 2012 4:24 AM

All replies

  • How about

    select * from openquery([ipserver], 'select top 1000 * from db.tablename')

    Also, perhaps you can specify column names you want to select from that table name?


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    • Proposed as answer by Kalman Toth Thursday, December 13, 2012 5:16 AM
    • Marked as answer by Kalman Toth Thursday, December 27, 2012 10:46 PM
    Thursday, December 13, 2012 4:24 AM
  • when i select some column 

    it run success 

    i want know what happen and 

    can you give me to resolve them


    • Edited by xuyen le Thursday, December 13, 2012 4:49 AM
    Thursday, December 13, 2012 4:39 AM
  • How many columns and the total sizes of a row in that table? I suggest to add column one by one until you hit that limit.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 13, 2012 4:44 AM
  • How much memory do you have on your computer? What is @@version?

    Kalman Toth SQL 2008 GRAND SLAM
    New Book: SQL Programming & Database Design Using Microsoft SQL Server 2012

    Thursday, December 13, 2012 5:18 AM
  • my memory have more 19GB

    and version is 

    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)  
    Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 


    Thursday, December 13, 2012 6:52 AM
  • and my database are about 12M record and size of a record 44byte 
    Thursday, December 13, 2012 6:53 AM
  • >my memory have more 19GB

    Yes, but on 32-bit it requires special setup to use all that memory unlike 64-bit.

    >and my database are about 12M record and size of a record 44byte

    Use the SSIS Import/Export Wizard for moving data across servers:

    http://www.sqlusa.com/bestpractices/ssis-wizard/


    Kalman Toth SQL 2008 GRAND SLAM
    New Book: SQL Programming & Database Design Using Microsoft SQL Server 2012


    • Edited by Kalman Toth Thursday, December 13, 2012 9:00 AM
    Thursday, December 13, 2012 9:00 AM
  • thank you 

    but memmory that i mentioned above is hdd 

    RAM is 4GB

    i want know what is  special setup(but on 32-bit it requires special setup to use all that memory unlike 64-bit.)? 

    Thursday, December 13, 2012 9:12 AM
  • You need to apply SP4 to your SQL Server 2005. Right now you're on the SP2.

    See http://sqlserverbuilds.blogspot.com/


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 13, 2012 1:44 PM
  • yes,

    but i can't change them, i haven't permisstion

    Friday, December 14, 2012 1:50 AM