From: Steven Lumos <steven@...>
Date: 2006-02-03T03:38:01+09:00
Subject: Re: Rails + Oracle

"Robert Hicks" <sigzero@gmail.com> writes:
> I have tried every connection string on the Rails site and it will not
> connect. I can create a regular dbi script and connect and pull out
> data.
>
> If someone is using Rails + Oracle can you post the relevent portions
> of your connection string? Please?!
>
> Robert

Problem is, there are SO many ways to configure Oracle.  The following
simple thing works for me:

development:
  adapter: oci
  database: SID
  host: SID
  username: scott
  password: tiger

(I believe 'database' isn't actually used.) Then I have this in
tnsnames.ora:

SID =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = host.domain.edu)(PORT = 1521))
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = sid)
    )
  )

On my Powerbook, HOST = localhost because I tunnel the database
connection over SSH.

Steve