# Error connecting to Oracle 10g w/ ActiveRecord **URL:** \ **Category:** Ruby\ **Created:** [March 6, 2007, 12:22am UTC](https://www.ruby-forum.com/t/error-connecting-to-oracle-10g-w-activerecord/87785 "2007-03-06T00:22:32Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![dfg59](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e0b2c6/32.png) [@dfg59](https://www.ruby-forum.com/u/dfg59)\ **Post date:** [March 6, 2007, 12:22am UTC](https://www.ruby-forum.com/t/error-connecting-to-oracle-10g-w-activerecord/87785/1 "2007-03-06T00:22:32Z")
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 ---
**Author:** ![dfg59](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e0b2c6/32.png) [@dfg59](https://www.ruby-forum.com/u/dfg59)\ **Post date:** [March 6, 2007, 2:35am UTC](https://www.ruby-forum.com/t/error-connecting-to-oracle-10g-w-activerecord/87785/2 "2007-03-06T02:35:28Z")
On Mar 5, 4:22 pm, Drew O. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > 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. It’s not an AR issue. There’s an issue with your Oracle client setup. See [Resolving ORA-12705: Cannot access NLS data files or invalid environment specified](http://www.dba-oracle.com/t_ora_12705_resolution.htm) Regards, Dan ---
**Author:** ![dfg59](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e0b2c6/32.png) [@dfg59](https://www.ruby-forum.com/u/dfg59)\ **Post date:** [March 6, 2007, 3:17pm UTC](https://www.ruby-forum.com/t/error-connecting-to-oracle-10g-w-activerecord/87785/3 "2007-03-06T15:17:57Z")
Daniel B. wrote: > On Mar 5, 4:22 pm, Drew O. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > > 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. > > It’s not an AR issue. There’s an issue with your Oracle client setup. > See [Resolving ORA-12705: Cannot access NLS data files or invalid environment specified](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