Hi,
got a problem with rails AR connecting to Oracle. On my Solaris box
everything is running fine, when I try to connect from my Linux box to
the remote database on Solaris using AR I get the following error:
------------------------
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/oci_adapter.rb:252:
undefined method `define_a_column'' for class `OCI8::Cursor''
(NameError)
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.0.4/lib/active_support/dependencies.rb:197:in
`require''
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record.rb:69
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.0.4/lib/active_support/dependencies.rb:197:in
`require''
from /usr/local/lib/ruby/site_ruby/1.8/rubygems.rb:175:in
`activate''
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:23:in
`require''
from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.0.4/lib/active_support/dependencies.rb:197:in
`require''
from ./script/../config/environment.rb:39
from script/server:42:in `require''
from script/server:42
----------------
Using sqlplus on Linux and the service from tnsnames.ora I can connect
to the database -
how should my database.yml look like for remote Oracle access? Is this
the problem or something else?
Has anyone a clue for me?
tia,
kayhtee