Comments on Andrew Beacock's Blog: How to change your Rails database adapter from OCI...

A bit late in the day as Andy's blog is dated June...

2008-04-30T16:47:00.000+01:00

A bit late in the day as Andy's blog is dated June 2007 but I have just been having the same problem as Dan.

My solution is on my Blog

Hello, guys.It did work. I copied oci.dll, oraocie...

2008-04-15T04:30:00.000+01:00

Hello, guys.

It did work. I copied oci.dll, oraociei11.dll to Windows\System folder.

In the previous comment, I've made a mistake. The oracle db was on a remote machine.

Thanks.

Hello, guys.I'm using rails 2.0.2, with Oracle RDB...

2008-04-14T15:37:00.000+01:00

Hello, guys.

I'm using rails 2.0.2, with Oracle RDBMS 11g on Windows XP.

I've installed:

-ruby-oci8 (used ruby-oci8-1.0.0-mswin32.rb)
-activerecord-oracle-adapter (downloaded as written in comments)

Rails, start fine. But when I see the application environment, web page says:

=======================
OCIError in Rails/infoController#properties

ORA-12154: TNS:could not resolve the connect identifier specified

RAILS_ROOT: C:/eclipse/workspace/test
Application Trace | Framework Trace | Full Trace

env.c:257:in oci8lib.so
======================

I've installed oracle client 11g, and SQL developer works fine.
But my rails app doesn't. I couldn't find the solution, anybody helps?

Glad you got it working, always happy to help!

2008-01-15T21:58:00.000Z

Glad you got it working, always happy to help!

The environment now works correctly. Thank you fo...

2008-01-15T21:56:00.000Z

The environment now works correctly. Thank you for your help.

Dan,Now that you have the gem installed does it wo...

2008-01-15T21:11:00.000Z

Dan,

Now that you have the gem installed does it work or are you still having problems? If you are then please post a detailed log and I'll see if I can be of any use.

Thanks for your help. I have Oracle Enterprise RD...

2008-01-15T20:54:00.000Z

Thanks for your help. I have Oracle Enterprise RDBMS 10.2.0.3 installed on Windows XP. This is what I had to execute to get activerecord-oracle-adapter installed.

gem install activerecord-oracle-adapter --source http://gems.r
ubyonrails.org
Bulk updating Gem source index for: http://gems.rubyonrails.org
Successfully installed activerecord-oracle-adapter-1.0.0

BTW - my version of rails is 2.02 and gem is 0.9.4

Dan,Here's some more information on the gem missin...

2008-01-15T20:17:00.000Z

Dan,

Here's some more information on the gem missing issue, not sure if any of this helps, it's not a gem I've installed - http://www.ruby-forum.com/topic/135231

I'm doing my Rails development on an Ubuntu Linux system so there are going to be quite a number of differences but here are some suggestions:

* Have you installed DBI? On Linux it's called 'libdbi-ruby'

* Have you correctly installed OCI8? This is what I did on Linux:
tar zxvf ruby-oci8-1.0.0-rc2.tar.gz
cd ruby-oci8-1.0.0-rc2
ruby setup.rb config -- --with-instant-client
make
sudo make install

* Do you have the Oracle InstantClient drivers/libraries/utilities installed on Windows?
These are the Linux packages and versions that may or may not help!
oracle-instantclient-basic_10.1.0.4-2_i386.deb
oracle-instantclient-devel_10.1.0.4-2_i386.deb

I'm new to Ruby and following instructions from ht...

2008-01-15T16:53:00.000Z

I'm new to Ruby and following instructions from http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html

When I try to install rails specifying V 1.0.0 I get an error.
c:\ruby>gem install rails -v 1.0.0 --remote
Bulk updating Gem source index for: http://gems.rubyforge.org
Install required dependency activesupport? [Yn] y
Install required dependency activerecord? [Yn] y
ERROR: While executing gem ... (Zlib::BufError)
buffer error

When I install the current version of 2.0 version of rails it can't connect to Oracle.

gem install activerecord-oracle-adapter displays GemNotFound error.

I have installed the OCI8 adapter
ruby ruby-oci8-1.0.0-mswin32.rb

Is there another distribution that I should try. I'm using the one click rubyinstaller, ruby186-26.exe Thank you.

Dan,Have you got the activerecord-oracle-adapter g...

2008-01-15T11:51:00.000Z

Dan,

Have you got the activerecord-oracle-adapter gem installed?

The error message from script/generate suggests that you need to install a missing gem:

gem install activerecord-oracle-adapter

This is not a gem I've installed before as I added Oracle support by installing DBI/Ruby-OCI8.

Having a problem connecting to Oracle 10.2.0.3. I...

2008-01-14T22:22:00.000Z

Having a problem connecting to Oracle 10.2.0.3. I can connect using the sample test your connection code. But the ruby scaffold command generates the following error.
C:\comics_catalog>ruby script/generate scaffold Comic
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_a
dapters/abstract/connection_specification.rb:231:in `establish_connection': Plea
se install the oracle adapter: `gem install activerecord-oracle-adapter` (no suc
h file to load -- active_record/connection_adapters/oracle_adapter) (RuntimeErro
r)
Here is my database.yml
development:
adapter: oracle
database: LOCAL
username: ruby
password: ruby

Any clues? TIA, Dan

Holgi, thanks for the tip!

2008-01-06T19:21:00.000Z

Holgi, thanks for the tip!

Hey,when using JRuby with Oracle, I had to use:dev...

2008-01-06T16:38:00.000Z

Hey,
when using JRuby with Oracle, I had to use:

development:
adapter: oracle
host: localhost
database: XE
username: user
password: pass

HTH (someone :)

Niaz, you HAVE to use Oracle as your adapter if yo...

2007-11-10T14:29:00.000Z

Niaz, you HAVE to use Oracle as your adapter if you want to use the 'hostname/sid' connection method.

Apart from the above what do you type from sqlplus to get access? If you post that info I might be able to help further...

Hi,I am using the old way (ocl), but failing to co...

2007-11-09T22:43:00.000Z

Hi,
I am using the old way (ocl), but failing to connect to my development database. While I can connect to it from command prompt via sqlplus, RoR gives error.
My entry is:

development:
adapter: oci
host: ORCL
username: sac_cfg
password: myPass

If it helps, I have a database named ORCL installed in my local machine (Oracle 10g Enterprise Edition).
I also tried with my ip address but didn't work:
host: 10.16.35.164/ORCL

Your help would be greatly appreciated.

No problem Travis, and if you ever have any issues...

2007-09-10T23:22:00.000+01:00

No problem Travis, and if you ever have any issues with Rails and Oracle, please post a comment on this thread and I'll try my best to help you out!

Thank you!!!

2007-09-10T23:03:00.000+01:00

Thank you!!!