similar to: is Sql Server support built in?

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:

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

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, When i use the ''delete_all'' function to remove a few rows from my database, it causes a deadlock on the sql server. The delete seems to be successful, it then redirects to the ''view'' page, and the record does appear to be deleted as far as the ''view'' rails page shows. BUT if i go into sql query analyser, i can''t do a

Hi, I?m working on a rails application that uses data from an existing ms sqlserver 2000 database. Unfortunately I can?t get the connection to work properly. I used http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to make the connection. - Inserted the ado.rb - Changed my database.yml to development: adapter: sqlserver database: database_name host:

I''m trying to connect to a SQL Server db. I thought I installed the DBI component per the instructions, but its not working. When trying to start the ruby server, I get the message: Please install the sqlserver adapter: `gem install activerecord- sqlserver-adapter` But when I try to install the repository, I get this error message: could not find activerecord-sqlserver-adapter

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

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

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

I have an app that needs to retreive data through an ODBC connection on a windows platform. Has anyone done this? Would someone be able to walk me through it? or point me to the relavant docs. My searches haven''t turned up any usefull information so far. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson

Hi... I am new to RoR development, and Web development in general (but have about 25 years of IT/software experience - just not in the Web area)... I have a really good RoR 2.X book that I have read and reread a few times and starting to try to apply what I read... Have a Web app that I need to write at work, and prove to folks that RoR is THE_WAY, despite their ASP .NET protests otherwise... So,

I just started investigating Ruby on Rails and am trying the tutorial. I need to connect to a SQL Server 2000 database for testing purposes. I followed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in

i have a problem with the datetime format of rails. i am unable to save a dataset to the db. here''s the error message -- the original error message was in german, so i translated it -- i get: DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Couldn''t convert a char-Datatype to datetime HRESULT error code:0x80020009

Hey there all, Is there some way to tell rails or sql server to ignore the time in a datetime field when doing a comparison? For example, if I do something like select * from users where registration_date = ?, @date where @date might equal some user input like ''03/14/2006'' The result is nothing returned, because in my tables the datetime field looks like this: 3/14/2006

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

I''ve attached my database.yml I''ve installed gem install activerecord-sqlserver-adapter But when I navigate to a simple page I get the ActiveRecord::ConnectionNotEstablished error Any ideas what I should be checking? Ruby 1.92 Rails 3 Attachments: http://www.ruby-forum.com/attachment/5016/database.yml -- Posted via http://www.ruby-forum.com/. -- You received this message

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

Hello. I reeeeally want to get Instiki running at my day job, but they are Microsoft-heads. While I can probably sell them on trying Rails, they are definitely going to want the database to sit in our SQL Server instance with our other databases. I can''t get instiki to create the tables in sql server though (I''ve added ADO.rb, and gotten a connection). When I run the

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org