search for: sqlserver

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 repository Does anyone know where the sqlserver adaptor has gone for activerecord 2.0.2? Harley M...

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 locally or in a repository Anyone? --~--~---------~--~----~------------~-------~--~----~ You received this message because y...

...re. This works as long as samba is in "share" mode: [2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309) check_ntlm_password: guest authentication for user [] -> [] -> [nobody] succeeded When I try to attach samba share manually when logged in as the user running the sqlserver agent, it also works: [2006/09/30 17:58:43, 2] auth/auth.c:check_ntlm_password(309) check_ntlm_password: authentication for user [sqlserver] -> [sqlserver] -> [sqlserver] succeeded But when running the stored procedure, which causes the sqlserver user to login to the samba server I get...

...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 SQLServer 2000. Our application contains a lot of stored procedures and triggers and a legacy table structure. So for starters we have always and are always likely to run on Windows. * Is Rails on SQLServer ready for the prime time? * Have the issues with primary key names been resolved (Used to need to cal...

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]

...ary(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 SQLServer Fecha: 29/01/2019 19:17 De: Javier Marcuzzi <javier.ruben.marcuzzi en gmail.com> Destinatario: Jesús Para Fernández <j.para.fernandez en hotmail.com> Cc: Lista R <r-help-es en r-project.org> Estimado Jesús Para Fernández Yo se usar SQL Server con R, es más, ODBC es obsoleto por...

I am using authlogic for authentication in rails 3.0.3 with ruby 1.9.2 Using activerecord-sqlserver-adapter (3.0.5) windows with sqlserver database when i create user details in rails console, i am getting below error, >User.create(:login=>''test'',:password=>''test123'',:password_confirmation=>''test123'') ActiveRecord::StatementInvali...

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

Hi everybody, Im using sqlserver (sqlserver adapter). I think that is some bug. any idea? -- _________ Noel R. Morais

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

gday R gurus, has anyone seen this lm problem? When I add 2 bytes to the variable name (via names), lm returns an error. It's as if there's a limit to the size of the variable names. Any suggestions? thanks, John Strumila > names(y)[12:14] [1] "Log.SQLServer.Locks.RID.Lock.Wait" "Log.SQLServer.Lock" [3] "xxaa" > names(y)[12]<-"Log.SQLServer.Locks.RID.Lock.Wa" > my.formula<-as.formula(paste(paste("y$",names(y)[12:14],collapse="+",sep="&qu...

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

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 ('1000','1000','100','sip','SIP/1000-09388800','AddQueueMember','test,Local/1000 at sip,5,,Agent/1000,Loc...

...om /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:236:in `load_driver'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:154:in `_get_full_driver'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:139:in `connect'' from /usr/lib/ruby/gems/1.8/gems/activerecord-sqlserver- adapter-1.0.0.9250/lib/active_record/connection_adapters/ sqlserver_adapter.rb:47:in `sqlserver_connection'' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `send'' from /usr/lib/ruby/gems/1.8/gems/acti...

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.

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

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

...sub!'' called for [0, 0, 0, 0, 0, 0, 224, 43]:Array from c:/ruby/lib/ruby/1.8/date/format.rb:253:in ''_parse'' from c:/ruby/lib/ruby/1.8/parsedate.rb:9:in ''parsedate'' from c:/ruby/lib/ruby/1.8/gems/activerecord-1.14.2/lib/active_record_cnnection_adapters/sqlserver_adapter.rb:92:in ''cast_to_time'' from c:/ruby/lib/ruby/1.8/gems/activerecord-1.14.2/lib/active_record_cnnection_adapters/sqlserver_adapter.rb:82:in ''type_cast'' ... I think the problem comes down to sqlserver_adapter.rb, in the type_cast method, asking timestam...

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

...profiler I see the line "IF @@TRANCOUNT > 0 COMMIT TRAN" for IRB, but not my test. If I add "report.connection.commit_db_transaction()" after report.save the record does appear. Although I never ask for transactions, it is turning on "implicit_transactions" in SQLServer (in my test and IRB), but somehow the commit is never happening. Thanks for any assistance. Regards, Gary -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Ra...