similar to: Is mysql_compression supported?

I have a standalone batch program that is going to move data between two databases. I am taking advantage of the AR connection semantics in database.yml to get connections to these two DBs. But I want to do all of my DB access at the DBI/DBD level for performance reasons. I am having trouble getting access to the underlying DBI handle so that I can prepare SQL statements, execute them etc.

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

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

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

I hope this is the place to post errors, and solicit help....if not, my apologies... I inherited a RoR app, and it was working great for the longest time....however, i have recently started receiving the following error: ***************************************************************** A DBI::DatabaseError occurred in repairs#edit: IM002 (0) [unixODBC][Driver Manager]Data source name not

Hi, I have been encountering this error when I try to save text with japanese characters: DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Line 1: Incorrect syntax near ''20070730''. HRESULT error code:0x80020009 Exception occurred.: INSERT INTO categories ([category_name], [updated_at], [created_by],

I''m playing around with the Postback action recipe listed in the recipes book. Here is the default code given: def edit @recipe = Recipe.find_by_id(params[:id]) || Recipe.new if request.post? @recipe.attributes = params[:recipe] redirect_to :main_url and return if @recipe.save end end Here is what my code sort of ended up looking like, altho i''ve ripped it apart

After installing One-Click Rails and Postgres 8.1 on Windows, I tried to install the pure-ruby postgres adapter by running gem install postgres-pr It installed fine, and I can do this: G:\InstantRails\rails_apps>irb irb(main):001:0> require "rubygems" => true irb(main):002:0> require "postgres" => true But then if I specify in my config/database.yml to use

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

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

Greetings, I have an application that connects to a remote SQL Server database using DBI/ODBC. If I run the application via the Rails console, I am able to retrieve data and work with the database just fine. If, however I try to access it via the Web application itself, I get the following error: DBI::DatabaseError (S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source):

Yet another newbie question here. My setup is thus: I have lighty running with scgi (working fine) on windows XP sp 2. Rails 1.1 and ruby 1.8.x. The server and scgi are working. I know this because I can get a test page to work easily enough. I did the following: ruby script\generate model Recipe [following the Rolling with Rails Tutorial] ruby script\generate controller Recipe I also

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

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

Hello people... In the rails2.pdf Dave T says: Rails works with the DB2, MySQL, Oracle, Postgres,... The database drivers are all written in C and are primarily distributed in source form. Then he lists this site: http://ruby.scripting.ca/postgres/ Then he says, There is a pure-Ruby version of the Postgres adapter available. Download postgres-pr from the Ruby-DBI page at

I am having a strange issue. I have upgraded to ruby 1.9.1 to do some testing on one of my machines. My app accesses a MSSQL database to pull in some information. Everything worked fine with ruby 1.8.6, but now if I try to navigate to a page that accesses that database I get this error: DBI::InterfaceError in PagesController#company Unable to load driver ''ODBC'' (underlying

Hello, Does anyone know how to escape colons in YAML? The key in my yml is the domain with port number, but the yml file isn''t working with this setup: ###BEGIN production: ### THIS IS THE ONE I''m HAVING TROUBLE WITH ### 8.11.32.120:8000: GoogleMapsKeyforThisDomain exampledomain.com: GoogleMapsAPIKeyforThatDomain development: GoogleMapsAPIKeyforDevelopmentDomain ###END

New to rails. Installed rails on my XP desktop, and setup my first app that will use an existing SQLServer database. I am able to connect to SQLServer using odbc with following code. require ''rubygems'' require ''ActiveRecord'' ActiveRecord::Base.establish_connection( :adapter => ''sqlserver'', :mode => ''odbc'', :dsn

I an run a simple DBI app fine no issues. When trying it on FCGI on my server I get this error: Could not load driver (undefined local variable or method `e'' for DBI:Module) Anyone got any idea why this would error using FCGI? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk"

Hi all I''d like to create fixtures using Fixtures.create_fixtures But it seems that this one needs .yml files that have the same name like the table they correspond to: countries.yml => my_db.countries readers.yml => my_db.readers Is it possible to use any desired filenames somehow? some_cool_countries.yml => my_db.countries some_other_cool_countries.yml =>