Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Developer & Programmer » Open Database 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?
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 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
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 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.
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 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
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
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
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 Go to previous message
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 24 15:17:51 CDT 2008

Total time taken to generate the page: 0.05989 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.