similar to: Getting at DBI connection via ActiveRecord connection

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

require ''dbi'' # 0.4.2 dbh = DBI.connect(''DBI:ODBC:PACS'', ''username'', ''password'') This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver ''ODBC'' (underlying error: uninitialized constant DBI::DBD::ODBC) from

Hello guys, I was told by the client to install Perl DBI version 1.52 on a el6 box, by default el6 branch comes with DBI version 1.6x, this version is AFAIK not the desired one. First I tried installing DBI 1.52 from some rpm package [1], which had some dependencies, Perl 5.8.8 and dbd.4.4.x, this last package was also present el6, so it made conflict and it was not possible to install DBI 1.52

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

I''m getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1. ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, rails

I have the following code in app/controllers/processjobs_controller.rb # class ProcessJobsController <ApplicationController def index @ProcessJobs = ProcessJobs.find(:all) end end # This is my route file .. ActionController::Routing::Routes.draw do |map| map.resources :ProcessJobs map.connect '':controller/:action/:id'' map.connect

Hi, I trieed umpteen times to connect ruby on rails to MSSQL server using the standard procedures and I always get the samw error. As I was previously working with MYSQL I faced no problem .Now at a time critical situation I need a solution for this........... Open OLE error code:800A0E7A in ADODB.Connection Provider cannot be found. It may not be properly installed. HRESULT error

All, Just musing about this whole FastCGI thing (that I hadn''t even thought of since 1999 when looking at OpenMarket for a customer and even then it was "old"), and wondering when we might see projects/products that attempt to provide Ruby application services in a J2EE-like container. I see the Cerise project - any interesting information on that? I''m assuming

Has anyone attempted to run Rails inside of JRuby? Is that even possible? Aside from the performance implications, is it a bad idea? I''m thinking that it might be useful in very rare cases where a Ruby/Rails - equivalent of a Java solution may not exist yet. Any thoughts? Wes -- Posted via http://www.ruby-forum.com/.

I would appreciate any tips/clues/advice very much. I have started using ruby on rails and when the MS SQL Server database is on a different box than my dev box (where the RoR app is located) I can connect fine. However when I try to connect to a MS SQL Server database on the same box as my RoR app I get an error. I have tried to use the IP address of the dev box as the value of

Does any one know how to setup SQLserver with ruby1.9. It was working on an earlier version and now nothing works! I have installed the gems dbi ,dbd-odbc and activerecord-odbc-adapter and can connect in straight Ruby. However, using rails with database.yml nothing works! I hosed everything and reinstalled rails and now, I get Win32/Parite virus on ruby.exe. Any ideas? I''m losing

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

I noticed that some of the ActiveRecord adapters depend on ruby-dbi. I''ve just started to play with the ruby-dbi database driver DBD::Proxy, which allows me to connect to other ruby-dbi drivers running on other operating systems. What seems more practical, developing a ActiveRecord database adapter for DBD::Proxy, or would you just target a specific database, and just depend on

I try to install astcc. Make install gives me: DBI connect('database=astcc;host=localhost','astcc',...) failed: Unknown database 'astcc' at ./astcc-admin.cgi line 67 DBI connect('database=;host=','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at ./astcc-admin.cgi line 60 Ignoring that (!!! ;-) ) and going to the

Just upgraded my perl-DBD-SQLite rpmforge package to 1.25 which resulted in all applications trying to use it to fail. As it turns out the following happened: Newer versions of DBD::SQLite need a DBI version of at least 1.57. The rpmforge package *does* include this requirement. However, CentOS includes DBI 1.52 and doesn't provide newer versions. As a good administrator I'm using yum

I am curious about the opinionated opinion behind the decision.Was it performance? Complexity? Databases support or something else. I recently used Ruby:dbi and liked all the metadata that comes with the data. Performance looked good but I didn''t benchmark it so I don''t know which one execute faster. If I am not wrong Ruby:dbi offers true parameters binding which would be nice

On 1/21/20 10:10 AM, david wrote: > At 08:52 AM 1/21/2020, David G. Miller wrote: > > >> On 1/21/20 9:35 AM, david wrote: >>> Folks >>> >>> In a test Centos 8 installation as a guest of VirtualBox on Windows >>> 10, I want to install ffmpeg, and support for exfat. They're not in >>> the standard distribution (as far as I know), so I

I have a Centos 4 box that has been updated all the way to 4.6 without using the centosplus repository. Now I want to use the centosplus repository for Centos 4 to get the latest LAMP, mod_perl, perl and other perl modules so that I can install rt 3.6.6 and its necessary modules. However, for some reason, the latest perl package in the centosplus repository does not appear on the radar when

At 08:05 PM 1/21/2020, you wrote: > > On 1/21/20 10:10 AM, david wrote: > >> At 08:52 AM 1/21/2020, David G. Miller wrote: > >> > >> > >>> On 1/21/20 9:35 AM, david wrote: > >>>> Folks > >>>> > >>>> In a test Centos 8 installation as a guest of VirtualBox on Windows > >>>> 10, I want to install

Hi all... Please help me solve the issue. While trying to create a connection with MS SQL database in RubyOnRails, I''m getting a ‘Deprecated ..’ error. (I referenced a doc posted in net for the same.) System details: OS: Windows Xp Ruby version: 1.8.6 Rails: 2.1.2 Gems: 1.3.1 RadRails: 0.7.2