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

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

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

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

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

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

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

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!!!

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

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

Hello, guys.I'm using rails 2.0.2, with Or...

Glad you got it working, always happy to help!

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

Dan,Now that you have the gem installed do...

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

Dan,Here's some more information on the ge...

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

Dan,Have you got the activerecord-oracle-a...

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

Holgi, thanks for the tip!

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

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

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

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

Thank you!!!

Hello, guys.

It did work. I copied oci.dll,...

Hello, guys.

I'm using rails 2.0.2, with Or...

Dan,

Now that you have the gem installed do...

Dan,

Here's some more information on the ge...

Dan,

Have you got the activerecord-oracle-a...

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

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