No, I've run the -g as high as 512 without any effect. Noah
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 8:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" No I haven't. But without the -g setting, it should reserve 256 megs and I can't imagine that the oledb driver needs more then this to run. If you happen to have a system that isn't in production to play with the settings, then this may be something to try. Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Friday, July 27, 2007 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" Have you had any success playing with the '-g' startup parameter? Regards, Noah -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error "out of memory" I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/