Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
connecting to an oracle database on an hp server
jctown@nb.sympatico.ca
7/19/2006 7:37:00 PM
Well I'm at my wits end...
I have an oracle database on an HPUX box that I can connect to using
this code:
require 'oci8'
connection = OCI8.new('user','passwd','connectstring')
connection.exec("select table_row from table") do |row|
puts 'column 1: ' + row[0] # outputs "dummy: X"
end
Works beautifully, but when I set up a rails application I get
OCIError in ArtifactController#new
ORA-12154: TNS:could not resolve the connect identifier specified
Here is my database.yml file
===================================================
# MySQL (default setup). Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
# gem install mysql
# On MacOS X:
# gem install mysql -- --include=/usr/local/lib
# On Windows:
# There is no gem for Windows. Install mysql.so from RubyForApache.
#
http://rubyforge.org/projects/rub...
#
# And be sure to use new-style password hashing:
#
http://dev.mysql.com/doc/refman/5.0/en/old-c...
development:
adapter: oci
username: xxxxxxxxx
password: xxxxx
host: host_alias:port
# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
adapter: oci
username: xxxxxxxxx
password: xxxxx
host: host_alias:port
production:
adapter: oci
username: xxxxxxxxx
password: xxxxx
host: host_alias:port
I can't think of anything to check and google doesn't tell me much
except for
http://ruby.about.com/od/enterprise/ss/ruby_or...
Which is where I started out 3 hrs ago.
1 Answer
Chris Hulan
7/19/2006 8:12:00 PM
0
jctown@nb.sympatico.ca wrote:
> Well I'm at my wits end...
>
> I have an oracle database on an HPUX box
....
> Works beautifully, but when I set up a rails application I get
>
> OCIError in ArtifactController#new
>
> ORA-12154: TNS:could not resolve the connect identifier specified
>
> Here is my database.yml file
> ===================================================
>
> # MySQL (default setup). Versions 4.1 and 5.0 are recommended.
> #
> # Install the MySQL driver:
> # gem install mysql
> # On MacOS X:
> # gem install mysql -- --include=/usr/local/lib
> # On Windows:
> # There is no gem for Windows. Install mysql.so from RubyForApache.
> #
http://rubyforge.org/projects/rub...
> #
> # And be sure to use new-style password hashing:
> #
http://dev.mysql.com/doc/refman/5.0/en/old-c...
> development:
> adapter: oci
> username: xxxxxxxxx
> password: xxxxx
> host: host_alias:port
>
> # Warning: The database defined as 'test' will be erased and
> # re-generated from your development database when you run 'rake'.
> # Do not set this db to the same as development or production.
> test:
> adapter: oci
> username: xxxxxxxxx
> password: xxxxx
> host: host_alias:port
>
> production:
> adapter: oci
> username: xxxxxxxxx
> password: xxxxx
> host: host_alias:port
....
Found this Rails wiki
(
http://wiki.rubyonrails.org/rails/pages/HowtoConne...
)
and notice the database.yml they show is a bit different than yours.
Lots of info there about getting conencted
Cheers
Chris
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
connecting to an oracle database on an hp server
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password