similar to: SqlServer Activerecord Adaptor + VARCHAR(MAX) Woes

I have been trying to find the adtiverecord adaptor for MS SQL server and attempted to install with the command found on the http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer wiki page: gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org I then got the error message: ERROR: could not find activerecord-sqlserver-adapter locally or in a

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, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

Hi there, I''m running ROR 2.x on Win32 tried to run gem install activerecord-sqlserver-adapter --source http://gems.rubyonrails.org and get this: D:\>gem install activerecord-sqlserver-adapter -source http://gems.rubyonrails.org Bulk updating Gem source index for: http://gems.rubyonrails.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find

Good Evening, I need some advice. I am in a position at work where I''ve got the boss pretty excited about rails. I think I could swing the Next Generation version of our product to use rails as the platform, but I find myself a little hesitant to do so until I''ve answered a few issues that I''m hoping people on this list could help me with. Firstly, we are tied to

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

Hello people, I am starting to build an application in Rails using SQLServer. In fact, I''m rebuilding it from Java EE to Rails. I created a new project and managed to connect to the database using ODBC, so I ran a rake db:migrate. Everything worked fine: the database schema was copied to my schema.rb file. Here comes my problem: is there a command that creates ruby classes from the

Hello, Using Edge_Rails and SQL Server I get an error in my schema.rb file after issuing "rake migrate". database.yml --------------------------------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following

The activerecord-sqlserver-adapter gem is still sort of available via gems.rubyonrails.org, but it will not install on machines that have Rails 2.1 (or its version of ActiveSupport) installed. This has been confirmed with versions of rubygems through 1.2. This seems to indicate that Rails is no longer tested against the MSSQL adapter and that the adapter is also no longer tested against Rails

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:

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

So, I''ve used Rails to tie into a legacy system which is on SQL Server 2000 with a required timestamp field, DBTimeStamp. The field is defined in SQL Server as type timestamp, but when rails is pulling it in, it appears it may be casting to a datetime format. So, when I try to read or write to the field, it gives me a parsing error: NoMethodError: private method

Hi, Here im not able to connect with MS-SQLSERVER database with *.R-File. Previously i was able to do in R in different machine and configuration was R Ver-2.11.1 Package Installed : RODBC_1.3-2 And now where im doinig now there the same code im trying to execute but its not connecting. configuration is, R Ver-2.12 Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6) which

Hola, Yo empleo RODBC, previamente he creado el origen de datos ODBC en mi equipo y hago: library(RODBC) odbc_con <- odbcConnect("origenODBC") siniestros <- sqlQuery(odbc_con," SELECT * FROM tal.tal") odbcCloseAll() Con VPN en remoto y demás, sin problemas. Saludos. -------- Mensaje Original -------- Asunto: Re: [R-es] Conexion a

Olly Betts, Has anyone tested the new Edit Distance(SQLServer) algorithm compared to the current one? If you need any inditional information or code, please let us know. Thank you.

So I got my rails app to connect to the SQLServer via ODBC, and I can model/scaffold, yada yada.. but when I need to exec a stored proc using sql_server.rb I get undefined local variable or method `connection'' how can that be, if I can connect for everthing else? thanks -- Posted via http://www.ruby-forum.com/.

/usr/local/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb" -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 am writing a test outside of a Rails project, but ''require''-ing enough to use the ActiveRecord classes. It is connected to SQL Server 2005. It reads in XML and adds an ActiveRecord object like this : report = DvrStatusReport.new : report.x = y : report.save puts report.id This outputs a new id each time, but the record doesn''t appear in the the table according to

I am trying to upload word docs to an image column. I followed the cookbook for how to upload files and it works on a MySQL db (upload and download) on SQLServer however I get the following error DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Operand type clash: text is incompatible with image HRESULT error code:0x80020009 Also I when