Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Ruby - ActiveRecord

0

Hello,

can somebody help me? Where is my Misstake? Running is the Example-PersonalServer of the Standard-Installation.

require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connection(adapter: "sqlanywhere", database: "demo", user: "DBA", password: "***", server: "demo12")

class Contacts < ActiveRecord::Base
  self.table_name = 'Contacts'
end

res = Contacts.find(:all)

Error: in `build_arel': undefined method `bind_values' for #<Arel::SelectManager:0x270faf8> (NoMethodError)

I use: activerecord (4.1.8) activerecord-sqlanywhere-adapter (1.0.0) arel (5.0.0) sqlanywhere (0.1.6)

Thx, Pascal

asked 17 Dec '14, 08:31

pmichel's gravatar image

pmichel
1●1●1●1
accept rate: 0%

edited 18 Dec '14, 05:03

Volker%20Barth's gravatar image

Volker Barth
40.2k●361●550●822

how can i load the arel-visitor for sqlanywhere? i think, there ist my problem:

require 'rubygems'
require 'active_record'
require 'active_record/connection_adapters/abstract_adapter'
require 'active_record/connection_adapters/sqlanywhere_adapter'

ActiveRecord::Base.establish_connection(adapter: "sqlanywhere", database: "demo", user: "DBA", password: "***", server: "demo12")
ActiveRecord::Base.connection

class Contact < ActiveRecord::Base
end

Contact.select('id')

Error-Message:
...in `to_sql': undefined method `accept' for nil:NilClass (NoMethodError)

Thanks, Pascal

(18 Dec '14, 04:21) pmichel
One Answer:
active answersoldest answersnewest answerspopular answers
0

I use another gem that works perfectly with SQLAnywhwere:

gem 'activerecord-sqlanywhere-adapter', :git => 'git://github.com/Sharagoz/activerecord-sqlanywhere-adapter.git', :branch => 'rails40'

Just put the line above in the gem file, run bundle install, configure database.yml correctly and go.

permanent link

answered 18 Dec '14, 07:11

MarcosCunhaLima's gravatar image

MarcosCunhaLima
306●9●10●19
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×14

question asked: 17 Dec '14, 08:31

question was seen: 2,190 times

last updated: 18 Dec '14, 07:11

Related questions

Problem loading DBCAPI in macOS Sierra

Ruby 64 bit

Errors with Rails 3.0.10 & Ruby 1.9.2

Is Ruby 2.4.2 on Rails 5.1.4 supported by SQLAnywhere adapter gems?

Using sqlanywhere-0.1.5-x86-mingw32 with Ruby 1.9.2

Can't connect to Sybase via DBI in Linux with Ruby 2.1.0

Could not load dbcapi library in Rails 6.0.6 production mode

How to Connect Sybase to Ruby script

ruby sqlanywhere hangs in semop

Joining with a lateral getting an invalid correlation name