similar to: Conexion a SQLServer

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

Buenas El problema es el tipo dr columnas. Haynun bug q hace que haya q mostrar el tipo de columna mas largo al final de la consulta... Es un bug de los odbc de Windows.. Gracias Jes?s Obtener Outlook para Android<https://aka.ms/ghei36> ________________________________ From: Javier Marcuzzi <javier.ruben.marcuzzi en gmail.com> Sent: Saturday, March 3, 2018 12:02:10 AM To: Jes?s

Perdon, corrijo, es justo eso... En cuanto hay uan cadena de tipo varchar falla. Es por temas de codificaciones en el driver. ?Como cambio la codificacion? Un saludo Jesus ________________________________ De: David Luna <ofc587a87 en gmail.com> Enviado: viernes, 2 de marzo de 2018 15:02 Para: Jes?s Para Fern?ndez Cc: r-help-es en r-project.org Asunto: Re: [R-es] Problemas de conexion con

Buenas, Tengo un problema y es que intentando conectarme a una base de datos SQL Server, tras cosneguirme conectarme usando el paquete odbc, me deja acceder al contenido de algunas tablas (mediante un select), pero sin embargo en otras me pone lo siguiente: Error in new_result(connection en ptr, statement) : std::bad_alloc No entiendo muy bien porque me salta ese error, ya que desde SQL si

Buenas He visto el paquete mlr3, pero se que hay algun otro del estilo. Cu?l usais vosotros y por qu?? Un saludo Get Outlook for Android<https://aka.ms/ghei36> [[alternative HTML version deleted]]

Buenos días: ¿Hay alguna forma de conectar VBA de Excel con R, de forma que desde Excel se puedan cursar instrucciones de R?, ¿ y V.Basic con R? Gracias anticipadas. Saludos [[alternative HTML version deleted]]

Muchas gracias, Sergio. Saludos cordiales. Eduardo Freyre -----Mensaje original----- De: miguel.angel.rodriguez.muinos en sergas.es [mailto:miguel.angel.rodriguez.muinos en sergas.es] Enviado el: viernes, 12 de julio de 2013 12:39 Para: efreyre en movistar.es; r-help-es en r-project.org Asunto: RE: [R-es] Conexion excel vba con R y VBasic con R Hola Eduardo. Lo que buscas lo puedes

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

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

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

El problema es que te obligaran a usar tibbles y yo soy mas de data.table.... Get Outlook for Android<https://aka.ms/ghei36> ________________________________ From: Emilio L. Cano <emilopezcano en gmail.com> Sent: Friday, July 31, 2020 5:58:00 PM To: Jesús Para Fernández <j.para.fernandez en hotmail.com> Cc: r-help-es en r-project.org <r-help-es en r-project.org> Subject:

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

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.

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

Buenas tardes, Estoy tratando de realizar un update en SQL desde R: sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR") y me devuelve el siguiente error: *Error in sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR", : * * data frame column(s) Corteoptimo Cortediario not in database table* El problema es que sí existen esas columnas en SQL pero

Puedes poner el post de kaggle? Get Outlook for Android<https://aka.ms/ghei36> ________________________________ From: Emilio L. Cano <emilopezcano en gmail.com> Sent: Friday, July 31, 2020 6:05:57 PM To: Jesús Para Fernández <j.para.fernandez en hotmail.com> Cc: r-help-es en r-project.org <r-help-es en r-project.org> Subject: Re: [R-es] Mejor paquete machine learning Yo

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

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

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