Home » Open Source » Programming Interfaces » Oracle and Ruby On Rails
Oracle and Ruby On Rails [message #159552] Mon, 20 February 2006 04:31 Go to next message
Axle988
Messages: 2
Registered: February 2006
Junior Member
I've got a problem using Ruby on Rails with Oracle. I use this file .YML to connect:

development:
adapter: oci
host: xxxxxx
database: ENERGIA
username: User
password: Pass


test:
adapter: oci
host: xxxxxxx
database: ENERGIA
username: User
password: Pass


production:
adapter: oci
host: xxxxxxx
database: ENERGIA
username: User
password: Pass

But whem i try to connect to a table named platts (that is into ENERGIA schema) Rails tell me that it doesn't exist!!!.If i make the same in MySQL the problem doesn't exist.What's happen?
Re: Oracle and Ruby On Rails [message #159658 is a reply to message #159552] Mon, 20 February 2006 17:07 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Can you access the table using SQL*Plus? I think that Oracle needs to use ODBC to access ANY database other than Oracle.

David
Re: Oracle and Ruby On Rails [message #159777 is a reply to message #159658] Tue, 21 February 2006 08:40 Go to previous messageGo to next message
Axle988
Messages: 2
Registered: February 2006
Junior Member
Yea!
I've no-one problem using sql*plus or a programming language such as Ruby. This mistake happen only when i try to interrogate Oracle with Rails.
Re: Oracle and Ruby On Rails [message #159847 is a reply to message #159777] Tue, 21 February 2006 21:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If you signon through SQL*Plus to ENERGIA using the 'user' and 'pass' are you able to 'desc platts'?

David
icon5.gif  Re: Oracle and Ruby On Rails [message #293719 is a reply to message #159552] Mon, 14 January 2008 14:41 Go to previous messageGo to next message
martin.hoffmann
Messages: 1
Registered: January 2008
Location: europe
Junior Member
Hi,

did You tried oci8 instead of oci? Sometimes it works with 'oracle' instead of 'oci8' on my site. Here You can see my configfile:

development:
adapter: oracle
database: //192.168.0.2/SIDOFINSTANCE
username: nemouser
password: secretpass

by,
mrtn
Re: Oracle and Ruby On Rails [message #293728 is a reply to message #293719] Mon, 14 January 2008 14:58 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As he didn't connect since Feb 2006, I think you should not expect any answer.

Regards
Michel
Previous Topic: Problem Connection to 10g from .Net Service
Next Topic: PERL - bind_param
Goto Forum:
  


Current Time: Thu Mar 28 04:03:46 CDT 2024