I''m using the following configuration in the database.yml to connect to Oracle, however I could not connect while the settings seems to be correct: development_oracle: adapter: oci host: 127.0.0.1:8080/XE username: rubydb password: rubyrails What is wrong here? Can anyonbe help me? -- Posted via http://www.ruby-forum.com/.
Hey Tom,
Try setting up a TNSNAMES.ORA file.
It should look something like this:
XE (DESCRIPTION (ADDRESS_LIST (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 8080))
)
(CONNECT_DATA (SID = XE)
(SERVER = DEDICATED)
)
)
Then in your database.yml you put:
development:
adapter: oci
host: xe
username: rubydb
password: rubyrails
You''ll have to look up where in your installation the TNSNAMES.ORA
file should live, but this solution works like a charm for me.
-wilig
On Mar 28, 2006, at 11:14 AM, Tom Hofte wrote:
> I''m using the following configuration in the database.yml to
> connect to
> Oracle,
> however I could not connect while the settings seems to be correct:
>
> development_oracle:
> adapter: oci
> host: 127.0.0.1:8080/XE
> username: rubydb
> password: rubyrails
>
> What is wrong here?
>
> Can anyonbe help me?
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
William Groppe wrote:> Hey Tom, > > Try setting up a TNSNAMES.ORA file. > > It should look something like this: > > XE > (DESCRIPTION > (ADDRESS_LIST > (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 8080)) > ) > (CONNECT_DATA > (SID = XE) > (SERVER = DEDICATED) > ) > ) > > Then in your database.yml you put: > > development: > adapter: oci > host: xe > username: rubydb > password: rubyrails > > You''ll have to look up where in your installation the TNSNAMES.ORA > file should live, but this solution works like a charm for me. > > -wiligHi Willig, Thank you for your help! I works now just fine -- Posted via http://www.ruby-forum.com/.