similar to: Rails and SQL Server 2005, NULL String Settings

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

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

Many thanks to all who helped with my question last week about how to take the output of lm() and turn it into code that can be run on systems without R (using SQL, C, etc). This is a summary of the answers, caveats, and a solution including a little Perl script I wrote to do this. Brian Ripley pointed out an important caveat to this whole process - the model.matrix could contain R functions that

Hi all...... please give me an example that use SQL in models to handel data in the data base. with "sql.execute" or any other possible way.. thankx --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

I just checked out the latest sqlserver_adapter.rb from the SVN repository, and it seems to work fine. -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Neville Burnell Sent: Thursday, 24 March 2005 2:25 PM To:

Hi, We''re trying to rewrite veeeery old Rails app that we successfully managed to move to 1.2.6 and now we''re trying with 2.1.0. One of the problems is caused by :include in AR.find. Rails 1.2.6 generates totally different SQL query than 2.1.0. Here''s Rails find query and generated SQL queries: Foo.find(:all, :include => :ticket, :conditions =>

Rails SQL Views 0.5.0 is now available from http://rubyforge.org/frs/?group_id=2435&release_id=8685 and shortly as a Gem (gem install rails_sql_views). More information on Rails SQL Views can be found at http://activewarehouse.rubyforge.org/rails_sql_views/ This release finally fixes the SchemaDumper issues, including the necessary select statement for the view. It also introduces PostgreSQL

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael

hOLA A TODOS QUISIERA SABER COMO LOGRO TRABAJAR CON RAILS Y SQL SERVER 2000 COMO GESTIONO USO MI DB EN SQL SERVER, COMO VINCULO UNA APP EN RAILS CON ESTE GESTOR DE BD. O UNA BASE DE DATOS EN SQL, NO EN MYSQL U OTRA. SINO EN SQL gRACIAS. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.

Boa noite pessoal, seu muito trabalho mas consegui fazer conectar o sqlserver com ruby mas só que quando vou inserir qualquer dado da o seguinte erro ODBC::Error: 22008 (242) [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.: INSERT INTO [usuarios] ([created_at], [updated_at], [login], [senha],

Hey Ryan, I asked this question awhile back, but any support planned for table returning functions, or stored procedures? I''m envisioning basically a mutable model class where you have 1 or more instance variables defined (with default values) that are used in the SQL queries as input parameters. When you instantiate the class you can specifically define these parameters or use the

[copying the rails list for more feedback] On 3/17/06, Jakob Skjerning <jakob@mentalized.net> wrote: > I believe you''re currently the man putting a lot of effort into the > Rails SQL Server adapter - is this correct? Somewhat. I am maintaining the SQLServer adapter but I''m not doing quite as much as I''d like with it and you certainly can''t call

I just want to ask if we connect to SQL server what will be used? Windows authentication or SQL Server Authentication? I had tried Windows authentication and I was connected, however I don''t know where and how to create tables. In SQL Server Authentication it needs login name and password. I''m confused what info I will use here either my log-in name and password using my

Hello Railists, I have a piece of Ruby on Rails code that has a complex SQL query (well, not that complex, but as far as I know beyond the ORM capabilities) and for my taste it has too many strings and harcoded values. I''d like to improve it as much as possible, so my question is open ended, what else can I do to improve it? Some particular issues I have - Is there a way to get a table

Hi, I tried to remove the text starts by "--" to the end of the line as below sql=c("-- This is a comment line", "select sysdate -- This is a comment Text" , " from dual ") >sql [1] "-- This is a comment line" [2] "select sysdate -- This is a comment Text" [3] " from dual " I try to have this > sql

Using SQL or activerecord I am not sure how to search all fields for a specific value ? I know how to do this by just writing ruby code. To do it in SQL or an activerecord find w/condition, I don''t know how. I actually am supposed to combine an find w/ condition and a search all fields for a value and AND those together. I think perhaps it can''t be done with a single find ?

Hi all! Recently I discovered that AR tries to treat question marks inside SQL string literals as parameters, however this behaviour shows in very rare cases, for example (very odd, but...): User.where("NOT EXISTS (#{ Comment.where(''user_id = users.id AND body ILIKE ?'', ''%?'').to_sql }) AND created_at > ?", Date.yesterday).to_sql It will fail,

Friends, I was wondering if any Rails/SQL Server experts could offer some help in regards to a question I had. Lately I have been getting some "timeout expired" errors in rails for some of my find_by_sql queries. When I load these pages, they often take upwards of 2-4 minutes and eventually they throw a timeout exception. When I run the exact same query in SQL Enterprise Manager, the

I am trying to get access to a Microsoft SQL Server 2k installation on my network. To this point I''m not having any luck. I''ve followed the instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an

I see some possible issues with the SQL that is being generated by the firebird adapter. Every SQL is being generated on the fly by concatenating strings. Can someone please explain why the SQL is being generated the way it is? I cannot use this in real life for a couple of reasons: 1. This introduces a security hole because a user, accidentally or deliberately, could potentially submit a