Take Ruby out of the picture to make sure it is not your Oracle client.
Run sqlplus to ensure that you are connecting properly and the path is
well-defined.
On Wed, Jul 22, 2009 at 7:23 AM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
I have upgraded to 2.0.2 by using
Guys,
I am putting this thing again and again, so you can guess that i need
it badly.So, Please help me if you can.
I am using:
Ruby 1.8.6
Oracle 9i
Windows XP
and i am done with ruby ruby-oci8-0[1].1.13-mswin.rb
But when i run this code to check whether i am able to connect to the
Oracle
Hi Dheeraj,
Had never connected to oracle db.
Did the below and was able to connect to the db.
1. Downloaded ruby-oci from
http://rubyforge.org/frs/download.php/56929/ruby-oci8-1.0.6-x86-mswin32-60.gem.
This downloads as tar file.
2. Renamed the file from ruby-oci8-1.0.6-x86-mswin32-60.gem.tar
On Wed, Jul 22, 2009 at 12:02 AM, Jared Quinert ja...@kilmore.info wrote:
Is there a need for a ruby-testing group?
If you create one, I will join it.
Željko
--
http://watirpodcast.com/
--~--~-~--~~~---~--~~
You received this message because you are subscribed
Any help/solution?
On Wed, Jul 22, 2009 at 1:18 PM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
Hi Tony,
I tried one again that u mentioned here but i am still getting :
C:\testwatirruby testcon.rb
c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:52:in `init': OCI Library
Initialization
Hi Dheeraj,
Check the entry in your tnsnames.ora file. It should be something like this
:
*SOMENAME* =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = someIP)(PORT = somePORT))
)
(CONNECT_DATA =
(SERVICE_NAME = someDBName)
)
)
Now, just enter the
Sir,
My code is:
require 'oci8'
OCI8.new('mlbread', 'mlbread', '172.16.100.110:1521/Test').exec('select *
from bam_order.ec_invoice where order_id = 139920') do |r|
puts r.join(',')
end
My TNS Entry is:
Test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Hi,
Try the following :
require 'oci8'
OCI8.new(mlbread, mlbread, Test).exec('select * from
bam_order.ec_invoice where order_id = 139920') do |r|
puts r.join(',')
end
Srinivas
On Wed, Jul 22, 2009 at 4:21 PM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
Sir,
My code is:
require
Hi Dhiraj,
As per your previous mail, you are having an older version of oci8 i.e
1.0.6.Pls upgrade it to 2.0.2 try.
Srinivas
On Wed, Jul 22, 2009 at 5:31 PM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
Attached is the screen shot, where it shows that ruby-oci8-1.0.6-mswin32 is
I have upgraded to 2.0.2 by using
http://rubyforge.org/frs/download.php/56929/ruby-*oci8*-1.0.6-x86-mswin...http://rubyforge.org/frs/download.php/56929/ruby-oci8-1.0.6-x86-mswin32-60.gem.
and then:
C:\rubygem install ruby-oci8-2.0.2-x86-mswin32-60.gem
Successfully installed
Well, in that case, i'm not sure why its not working for you. Because for me
it works perfectly fine.
Srinivas
On Wed, Jul 22, 2009 at 5:53 PM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
I have upgraded to 2.0.2 by using
You probably need to take this to one of the more mainstream ruby
discussion lists. This is really outside the scope of Watir since
it's really more of a general ruby language question, and also we seem
to have reached the limits of the folks here who are familiar with
this since they have told
Hello Dheeraj,
You need this library http://ruby-oci8.rubyforge.org/en/
The site explains all you need to set it up.
Regards,
FK
On Tue, Jul 21, 2009 at 10:06 AM, Dheeraj Gambhir
checktestingthi...@gmail.com wrote:
Hi All,
I have tried my level best to connect to oracle using ruby but
Install http://rubyforge.org/projects/ruby-oci8/
And example of code:
require 'oci8'
connection = OCI8.new(user, pass, scheme)
sql = 'select * from table'
connection.exec(sql) do |row|
puts row
end
On 21 июл, 17:06, Dheeraj Gambhir checktestingthi...@gmail.com
wrote:
Hi All,
I have
Hi,
I am getting oci.dll missing error on running the code given by you:
require 'oci8'
connection = OCI8.new(mlbread,mlbread,MLBD)
sql = 'select * from bam_order.ec_invoice where
created_datesysdate-2'
connection.exec(sql) do |row|
puts row
end
Regards
D G
On Jul 21, 6:25 pm, Ivan
I am using oracle client from past 2 years, so do i need to re-
install?. I don't think so.
Now after re-installing ruby-oci8-1.0.6-mswin32, i am getting the
following error now:
C:\Program Files\Watir\examplesruby oraclecon.rb
warning: ActiveRecord-JDBC is for use with JRuby only
If i run this code to check whether i am able to connect to the Oracle
database server or not:
ruby -r oci8 -e OCI8.new('mlbread', 'mlbread', 'MLBD').exec('select *
from bam_order.ec_invoice where order-id2316027') do |r| puts r.join
(' | '); end
It gives me:
C:\rubyruby -r oci8 -e
you can also use the db2 library or the active record library they are
better then the OCI8 stuff
On Tue, Jul 21, 2009 at 7:14 PM, Dheeraj
Gambhirchecktestingthi...@gmail.com wrote:
Hi,
I am getting oci.dll missing error on running the code given by you:
require 'oci8'
connection =
You may also find a lot more folks who know about doing this sort of
thing in the main ruby forums than you will here where many of the
folks have never needed to connect to a db (or if they did it was
mysql or ms-sql) in order to test against a web UI.
On Jul 21, 8:36 am, karim rayani
That's one point that I find interesting. Once Ruby found its way into
my toolkit, I've used it to hit databases, web services, parse xml,
simulate flat-file responses from banks and more. A lot of my watir
scripts are simple integrations between data that I get from these other
approaches.
Some great points Jared, for me it comes down to this..
There are probably a ton of great things I could do using Ruby, but
unless I'm sure one of them will pay back the time investment to
figure out how to do them, I likely won't get around to them because
I have so many other things that I
Hello Jared,
I'm a software tester and my interest in Ruby started a few years ago when I
found out about Watir.
At some point I started a blog (in Portuguese) about How to do x in
Ruby, which would be basically a repository of solutions to the problems I
came across, but it never took off.
I am using:
Ruby 1.8.6
Oracle 9i
Windows XP
and i am done with ruby ruby-oci8-0[1].1.13-mswin.rb
But when i run this code on cmd to check whether i am able to connect
to the Oracle
database server or not:
ruby -r oci8 -e OCI8.new('mlbread', 'mlbread', 'MLBD').exec('select *
from
23 matches
Mail list logo
