The oracle:thin syntax is usually for JDBC connections in my experience. 
 Per the readme <https://github.com/rsim/oracle-enhanced> and my own 
experience, you'll want to specify 1 of 4 possible formats.

1.  just the TNS name as the database key like 'xe' if you have the 
TNS_ADMIN environment variable set to point to where your tnsnames.ora file 
is located, and it contains the TNS descriptor for your server

2.  the url, port, and SID for the database, like '//localhost:1521/xe

3.  the url, port, and SID as 3 different config keys, database: xe, host: 
127.0.0.1, port: 1521

4.  The full TNS descriptor (DESCRIPTION = .. )

I've had the most luck with option 4 since it is the most explicit.  I've 
had cases where TNS_ADMIN wasn't set right or the ruby process wasn't 
getting that environment variable (like when running under apache) and even 
when forcing it to be set, things still weren't right.  It should be as easy 
as specifying the TNS name, but I have not found that to always be the case.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/rubyonrails-talk/-/xBe8Ure9McIJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to