similar to: memory leak using sql server

i''m running ruby 1.8.5 and rails 1.2.3 on windows with a bunch of mongrels that are proxybalanced via apache 2.2.4 the db adapter i''m using is the sqlserver one in ADO mode. so it''s using win32ole. when a mongrel service is freshly started it consumes about 40 megs of ram. but about each and every request is leaking memory. about 20 megs per hour(!!!). so after half a

Hello all, I''m having trouble with the WIN32 file opening. I don''t'' know how to tell if this is a WIN32OLE issue or an issue with the application (Adobe Illustrator CS2) Review the included files below, which exist within a rails application. When IllustratorMinimalTest is run, #testFullPath succeeds, #testFileName fails. Thanks in advance for any advice on how to

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

Greetings all. I have some controller code that uses win32ole (only available on windows). This code is now solid, and I''d now like to resume development on (any) other OS(grin). But alas, the controller bails because the OS specific library can''t be found. Can I conditionally specify action code compilation (and a require ''win32ole'') based on OS or

Greetings all. I have some controller code that uses win32ole (only available on windows). This code is now solid, and I''d now like to resume development on (any) other OS(grin). But alas, the controller bails because the OS specific library can''t be found. Can I conditionally specify action code compilation (and a require ''win32ole'') based on OS or

If you are running on Windows you can use create and read speadsheets using the ''win32ole'' require This sample should give you the basic idea ------ def export require ''win32ole'' @sort_by = ''last_name'' current_user = ''steve'' @records = Contact.find( :all, :conditions =>

Hi all, I am trying to create word document in ruby using WIN32OLE. as.. require ''win32ole'' word = WIN32OLE.new("Word.Application") word.visible = true word.documents.add selection = word.selection word.Selection.TypeText "This is some text." ... .. . Can we set header and footer to document? I want to generate a document such that its header contains an

I''m evaluating FXRuby for my application. So far everything is going pretty well. The news on the book is good, but I wish it were available today! First off, I''m not much of a Windows programmer (that''s what makes FXRuby so valuable to me). I''m using win32ole to interface to a custom ocx. Calling methods of the ocx works fine. Now I need to receive event

Hi everyone, So, who wants to rewrite the WIN32OLE library? I think I''ve got most everything you''ll need in the windows-pr library, such as Windows::COM::Automation, Windows::Error, etc. I can add anything that''s missing. Advantages include: * No compiler required * Easier to debug * A potentially better and more flexible interface * The current WIN32OLE library is

Hi, I am using features of MS Word 2003 on Win XP in my rails application. The server has Win XP installed. I am able to open a document, save as HTML etc. if I run the app using mongrel_rails start ... on command prompt. I use the Win32OLE support for Ruby: doc = WIN32OLE.new(''Word.Application'') However, at the deployment site, I have configured the app to run as a Windows

The SQL Server adapter can currently operate in two modes, ADO and ODBC, each of which uses a different interface to access the db. The ADO interface is currently the default, while ODBC can be specified as an option. I propose this situation is reversed, and that use of the ADO interface is deprecated, if not removed altogether. Here are some reasons, I'm sure there are more: a) ADO uses

Hi all, I am newbie to Ruby and web programming as well. My show.rhtml is like, . .. ... <% require ''win32ole'' %> <% ie = WIN32OLE.new(''InternetExplorer.Application'') %> <% ie.visible = true %> <% ie.gohome %> ... .. . At server, when I access http://.../show it''ll open Iexplorer.exe as expected, but when I access same from

Dan/Park, What are your thoughts about implemented portion of the win32utils family that are written in ruby utilizing WIN32OLE. I have found myself writing decent amount of ruby code accessing the Windows Scripting Host (WSH) object models. I have a few scripts which could be added. I do not believe the functionality is currently available with win32utils: - map network drives -

Hi all, I came across this page today: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winprog /winprog/using_the_windows_headers.asp Based on that, I think we need a patch for mkmf when on Windows that sets _WIN32_WINNT automatically based on platform. This is the basic code I''ve come up with: require "mkmf" require "win32ole" require

Bugs item #26975, was opened at 2009-08-21 10:52 You can respond by visiting: http://rubyforge.org/tracker/?func=detail&atid=411&aid=26975&group_id=85 Category: win32-sapi Group: Code Status: Open Resolution: None Priority: 3 Submitted By: Daniel Berger (djberg96) Assigned to: Nobody (None) Summary: Two test failures on XP virtual machine Initial Comment: Ruby 1.8.6-p383 VC++ 9

To start I will say I have read through the read "Problem with threads" to try and work around this problem, but I do not think I understand what is happening enough to make use of the info I found there. My app is pretty basic and does some text processing on 2 files and uses WIN32OLE to take the data and put it an excel sheet. The processing is really fast, but loading up Excel

Hi, im trying to create an application for multiple customers, where data shouldnt be accessible to others. So ive added a customer_id to every db-table where it matters. Question: How can i add a Statement to find and other sql-commands so i just pull out the ones belong to the customer, without having to add :customer => customer to every find query? Whats the easiest way? a before_filter

Hi all, I got the answer how to click on ''ok'' button. But still i have two problems --- that code is not working when im trying to run that code through the exe file of that ruby file which is using that code. and second one is i want to capure the text of that popup.. i tried this with no success #----- js_dialog.rb ----- require ''win32ole'' require

Hi I have the following code, which makes use of an sql statment to get the results required. However this just doesnt seem right for rails, as ive managed to develop the whole project without using any other pure sql. Is there a cleaner way of doing this, but gaining the same results. thanks scott #sql to find all invoices pSql = "SELECT DISTINCT invoices.id,

Im upgrading my dovecot from 2.1.14 to dovecot 2.2.1 on linux. Im using the same configuration file against my MySQL db and getting the following error: doveconf -n # 2.2.1: /opt/dovecot221/etc/dovecot/dovecot.conf doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver dovecot-sql.conf: # The mysqld.sock socket may be in