From: Peter Bailey <pbailey@...>
Date: 2007-06-01T20:44:36+09:00
Subject: Re: Help with Ruby < - > Oracle Connectivity

Brian Candler wrote:
> On Fri, Jun 01, 2007 at 03:45:58AM +0900, Peter Bailey wrote:
>> 
>> end
>> as above, but it's interrogating the same database.
>> 
>> First, I simply connected to the database using the SQLPlus initial GUI. 
> 
> Can you connect using the sqlplus command line? I didn't even know that
> sqlplus came in a GUI variant. (Are you sure it's SQLPlus, and not 
> something
> like Toad?)
> 
> Your later post says that you connect to "grpprod". In that case, try 
> the
> pure oci8 script I posted before, using "grpprod" as the database name. 
> And
> try your DBI script with
> 
>     DBI.connect("DBI:OCI8:grpprod","user","passw")
> 
> Can you show your entire /etc/tnsnames.ora ?
> 
> Brian.

Here's my tnsnames.ora file, Brian.

# tnsnames.ora Network Configuration File: 
E:\live\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
GRPPROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = graphicsdb-prod.bna.com)(PORT = 
1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = GRPPROD.bna.com)
    )
)

I put in what you suggested above and, it does seem to be actually 
talking to the database, and, it's respecting my script's error 
presentations.

require 'oci8'
require 'dbi'
   begin
     # connect to the Oracle server
     #dbh = 
OCI8.new('oracleuser','oracle2user','//graphicsdb-prod.bna.com/grpprod.bna.com"')

     #dbh = 
DBI.connect("DBI:OCI8:ORCL:graphicsdb-prod.bna.com/grpprod.bna.com", 
"orcauser", "orca2user")
     dbh = DBI.connect("DBI:OCI8:grpprod","orcauser","orca2user")

     # get server version string and display it
     row = dbh.select_one("SELECT VERSION()")
     puts "Server version: " + row[0]
   rescue DBI::DatabaseError => e
     puts "An error occurred"
     puts "Error code: #{e.err}"
     puts "Error message: #{e.errstr}"
   ensure
     # disconnect from server
     dbh.disconnect if dbh
   end

With the above, I get:

An error occurred
Error code: 923
Error message: ORA-00923: FROM keyword not found where expected

Program exited with code 0

which is exactly what the script said to do, to report the exact errors, 
number and all.

-- 
Posted via http://www.ruby-forum.com/.