similar to: Using Views in ActiveRecord ?

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

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

Hello, after putting ADO.rb into Directory \ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ I created a Rails-Application with MS SQL Server 2000 as Database. Everything works fine, but into the nvarchar-Field "notice" i can''t store more than about 50 or 60 characters MS SQL Server Query analyzer says, this field has a length of 510 characters. What can i do to save up to the 510

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

Hello there! I am pretty close to being able to develop in rails, but I keep running into a problem with my setup in connecting to my MS SQL database. When I try to navigate to my control page, I get the "..but something went wrong" page. In the dev log I get the following error: Unable to load driver ''ADO'' (underlying error: uninitialized constant DBI::DBD::ADO) I

Hello all, I''m creating a many-many join table between ''homes'' and ''users''. Can it contain created_on? will AR update created_on, updated_on on this table? CREATE homes_users ( home_id int not null, user_id int not null, created_on datetime null, updated_on datetime null ) Thanks for your advice! -- ------------------------------ Apple MacBook.

Hello everyone, I am needing to resolve an error on sqlserveradapter revolving around a trigger on a table. When the AR object is saved, AR throws Cannot create new connection because in manual or distributed transaction mode. at from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'' In order to resolve this, I

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

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

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

Hello all, I am trying to connect to my remote MS SQL server from Ubuntu. I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver

I''ve got a left join problem of some sort connecting from linux FreeTDS/ODBC to SQL Server. It''s similar to the false post I had earlier, but this is a real problem. Here''s my code: def find_recipes_for_workorder @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :joins => ''left join workorder on

Hello all, I''m looking for suggestions for integrated Blog + Wiki (Bliki) apps. I''d prefer Rails, I want to hear opinions on all options! I''ve browsed through W:Bliki <http://en.wikipedia.org/wiki/Bliki>. Nothing in that list is immediately compelling. This is for my wife, who is not a technologist, and has a need to create a information-centric website.

HI all, I"m using 1.1.6 script/generate scaffolding. Why does the view/foos/list.rhtml use "foo.send(column.name)" to display the contents of each column? I had to change this to "foo[column.name]" to get the display right in a couple of models. Specifically, one model has a column named ''display'', is that conflicting with something internally to AR ?

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.

Hello All, I need to stub two class methods before a selenium call. The .rsel is : require ''mocha'' SalesConfigWork.stubs(:load_work_data) SalesConfigWork.stubs(:delete_work_data) setup :fixtures => :sales_config_works open "/" The Selenium test runner result is : undefined method `stubs'' for SalesConfigWork:Class Extracted source (around line *#0*):

Hi! I''ve just started using AR on top of SqlServer 2005 (through ADO: http://www.softiesonrails.com/articles/2006/06/28/activerecord-with-sqlserver-without-rails). Not a Rails site per se, but I''m using AR and ruby to build data aggregation tools. If you have used AR with SqlServer 2005 and met quirks or caveats of some kind, I''d be happy to get some feedback from your

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 all, I''m (sadly) on Win32, and I''m looking for a presentation app to create slides a-la DHH and others. Powerpoint is obvious, and painful to work with. Also how can a windows wonk do the formatted pasting of ruby code for the presentation ? Thanks! -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------

Hello all, I have a fixture under folder-grouping : ./fixtures/foo/bars.yml I need to reference the data in bars during functional test. methods.sort reveals ''foo/bars'' as a method in the current context (breakpointed), but I don''t know how to reference a method called ''foo/bars''. - OR - how should i reference the fixture when I''m using