Error connecting to Oracle 10g w/ ActiveRecord

[Drew Olson]

All -

I'm attempting to connect to an Oracle 10g DB with ActiveRecord. The
code is working fine on a different machine, so I'm assuming I've
somehow installed oci (although this machine is on an office internal
network). Up to this point, I've installed oci, ActiveSupport and
ActiveRecord. I also have instantclient installed and added to my path
and I have copied the two necessary .dll files from instantclient to
/ruby/bin. The error I'm receiving is below.

Thanks in advance,
Drew

OCIError: ORA-12705: Cannot access NLS data files or invalid environment
specified
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:184:in `logon'
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:184:in `initialize'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:584:in `new'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:584:in `new_connection'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:620:in `initialize'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:35:in `new'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:35:in `oracle_connection'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/oracle_adapter.rb:41:in `oci_connection'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/abstract/connection_specification.rb:262:in `send'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/abstract/connection_specification.rb:262:in
`connection_wi
thout_query_cache='
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/query_cache.rb:54:in `connection='
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/abstract/connection_specification.rb:230:in
`retrieve_conn
ection'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/base.rb:1140:in `add_limit!'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/base.rb:1102:in `construct_finder_sql'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/base.rb:997:in `find_every'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/base.rb:991:in `find_initial'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_recor
d/base.rb:417:in `find'
from (irb):2

 

[Daniel Berger]

All -

I'm attempting to connect to an Oracle 10g DB with ActiveRecord. The
code is working fine on a different machine, so I'm assuming I've
somehow installed oci (although this machine is on an office internal
network). Up to this point, I've installed oci, ActiveSupport and
ActiveRecord. I also have instantclient installed and added to my path
and I have copied the two necessary .dll files from instantclient to
/ruby/bin. The error I'm receiving is below.

<snip>

It's not an AR issue. There's an issue with your Oracle client setup.
See http://www.dba-oracle.com/t_ora_12705_resolution.htm

Regards,

Dan

 

[Drew Olson]

<snip>

It's not an AR issue. There's an issue with your Oracle client setup.
See http://www.dba-oracle.com/t_ora_12705_resolution.htm

Regards,

Dan

Dan -

Thanks, I saw that just after posting. Maybe I should talk to my friend
Google first next time.

-Drew