similar to: RoR on windows with MS SQL Server DBI:ADO driver Memory Leak

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

Based on this page: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer using this specification development: adapter: sqlserver database: database_name host: server_name username: user_name password: your_pw_here in database.yml for your SQL Server connection doesn''t work. Some debugging code reveals that only the password comes through into

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

i was suffering from a massive memory leak in my application. after searching and testing for quite a while i finally found that it wasn''t my app that had a leak but the win32ole support that was used by the ADO driver in sqlserver adapter. the solution to fix the leak was to install ruby 1.8.5p52 or 1.8.6p36 but sadly as soon i install one of the fixed releases mongrel won''t

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 =>

i''m running a bunch of proxybalanced mongrels on a windows server. and since the memory consumption of all those mongrels is getting too high i wanted to set up the DRb''ed ferret server. but script/ferret_start doesn''t work and seems to be written for linux (unix) only. is there a way to run it on windows? -- Posted via http://www.ruby-forum.com/.

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Hi all, Since I didn''t get any takers on the win32-ole rewrite I thought I''d take a stab at starting it. Here''s what I''ve got so far (along with some extra constants in Windows::COM only in CVS), but the call to CoCreateInstance() isn''t working. I''m not sure if I''m dealing with the IDispatch interface properly: # win32/ole.rb require

Have installed ruby-one-click installer 1.8.4-16 and rails. Am unable to get an app to talk to by SS2000 database using adapter: sqlserver. Is Sql Server support built-in, or do I need to install something else? -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment

Hi everyone, I have been following these forums closely for the last few months but this is my first time posting. Basically I am trying to get an Oracle SQL Developer Binary Large Object(BLOB/CLOB) file in as an R object in R. For those not familiar with a BLOB/CLOB file, it is basically lik a table that has cells that contain tables or files. By converting the large table into a BLOB/CLOB file

I have a rails app running on windows 2003 server under apache, connecting to a sql server databse on a different windows box. Ive seen the memory go from about 30M at startup to about 130M at the end of the day. Ive used a modified form the object stats code from ( I think ) Robert Klemme. This seems to show that the WIN32OLE object gets created often( and appear to not be getting cleared) Ive

I am trying to connect to a remote sql server and I am getting the following error: c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'': Open (DBI::Databa seError) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception

Hi everyone, It''s been more than a month since I last fired up Ruby or ActiveRecord, so imagine my surprise when, after getting the latest source and running the unit tests for MySql, I was greeted with a screen full of errors. I''ll come back to the MySql errors later. What follows is the output I get when I run the tests for SQL server. I installed ruby with the one-click

Request: Full description of mechanims required to intergrate current Ruby / Ruby on Rails with MS SQL Server 2005 Environment: * Ruby 1.8.6-25 (ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32]) * Rails 1.2.3 * ruby-dbi 0.1.1 (installed dbi,dbd_ADO) * OS: Windows XP Professional sp4 * MS SQL Server Express 2005 installed on local machine Background: I have used various settings for the

That's how I understand how flac.exe works with unicode under Windows: There's a flag win_utf8_io_codepage that is equal either to CP_ACP or to CP_UTF8. Initially it's equal to CP_ACP. Then flac.exe/metaflac.exe call get_utf8_argv() that do some things and sets win_utf8_io_codepage to CP_UTF8 on success. This is the only way to set this flag to CP_UTF8. The programs continue to work

I''ve been asked to make my app work on Windows Server 2003 and connect to SQL Server. I''m having trouble getting connected to SQL Server. It fails as follows: is not a class/module C:\InstantRails-1.0\ruby\lib\ruby\site_ruby\1.8\dbi\dbi.rb:499 in ''load_driver'' So, I went through the instructions on the Rails/MSSQL page. I installed the ADO.rb stuff. Also,

Hi, I tried the steps explained in this link: http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer The article t refers me to: src/lib/dbd_ado/ADO.rb But the file: dbi-0.1.0.tar.gz does not contain the src folder. Instead, it contains this file: \lib\dbd/ADO.rb Am I missing some steps, or this is a document inconsistency? Thank you, Alan -- Posted via

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

Hello! Well, I actually have dcom98 installed. I've started it with option /c (that unpacks all the files in one directory) and copied the files to windows/system. Otherwise the installation of dcom98 failed. But dcom should work as Internet Explorer needs it - and IE works fine. Might it be, that I should try an older version of wine? I've the impression that some programs worked better

Hi Folks I recently got back the message below form a company I suggested supporting WINE with their software. Is there any answer - or is it, as they suggest, a lost cause? The error I get from WINE is: RTG Bills (title) ADO error 1AD ActiveX component can't create object [OK](button) Is there anyway to have ActiveX & ADO work with WINE? Regards, Morgan. > No, RTG Bills won't