OraFAQ Forum: Programming Interfaces » Oracle and Ruby On Rails

Home » Open Source » Programming Interfaces » Oracle and Ruby On Rails

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle and Ruby On Rails [message #159552]

Mon, 20 February 2006 04:31

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?

Report message to a moderator

Re: Oracle and Ruby On Rails [message #159658 is a reply to message #159552]

Mon, 20 February 2006 17:07

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

Report message to a moderator

Re: Oracle and Ruby On Rails [message #159777 is a reply to message #159658]

Tue, 21 February 2006 08:40

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.

Report message to a moderator

Re: Oracle and Ruby On Rails [message #159847 is a reply to message #159777]

Tue, 21 February 2006 21:45

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

Report message to a moderator

Re: Oracle and Ruby On Rails [message #293719 is a reply to message #159552]

Mon, 14 January 2008 14:41

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

Report message to a moderator

Re: Oracle and Ruby On Rails [message #293728 is a reply to message #293719]

Mon, 14 January 2008 14:58

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As he didn't connect since Feb 2006, I think you should not expect any answer.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 09:02:33 CST 2025