[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Error connecting to Oracle 10g w/ ActiveRecord

Drew Olson

3/5/2007 11:23:00 PM

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

--
Posted via http://www.ruby-....
2 Answers

Daniel Berger

3/6/2007 1:30:00 AM

0

On Mar 5, 4:22 pm, Drew Olson <olso...@gmail.com> 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.

<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_reso...

Regards,

Dan

Drew Olson

3/6/2007 2:18:00 PM

0

Daniel Berger wrote:
> On Mar 5, 4:22 pm, Drew Olson <olso...@gmail.com> 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.
>
> <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_reso...
>
> Regards,
>
> Dan

Dan -

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

-Drew

--
Posted via http://www.ruby-....