Takehiro Kubo wrote:
> Hi,
> 
> On 2/7/07, Drew Olson <olsonas / gmail.com> wrote:
>> > Look for OCI.dll - it's a dependency for oci8lib.so. It should be 1.
>> > in the oci8lib's dir, 2. somewhere on the $PATH. There are maybe more
>> > options, for details see
>>
>> I was able to find OCI.dll by downloading the Oracle Instant Client. I
>> copied it to ruby/bin and now the previously mentioned error is gone.
>> Thanks for that. However, I'm seeing something new now. Any ideas?
> 
> OCI.dll only? You need at least two files. OCI.dll and oraociei10.dll 
> (Basic)
> or oraociicus10.dll (BasicLite).

Takehiro-

Thanks for your help! That seemed to solve the problem I was initially 
having. I am getting another error now, but I'm assuming this has to do 
with connecting to the database. The error is below. Does this mean I 
have connected incorrectly? I read that I should not be using :database 
within establish_connection. My method currently looks like so:

ActiveRecord::Base::establish_connection(
  :adapter=>"oci",
  :host=>"hostaddress/schema",
  :user=>"user",
  :password=>"pass")

Error:

c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:184:in `logon': ORA-12514: 
TNS:listener d
oes not currently know of service requested in connect descriptor 
(OCIError)
        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:418:in `find'
        from models.rb:14

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