yes i have and with use(require 'win32ole') it did not work. One thing i forgot to mention that oci8 did not install so i use the direct gem install by get the gem oci8 from rubyforge site. but i am not sure is that related to that or not. in my framework we write the log details in dataabse
*** LOCAL GEMS ***
actionmailer (2.3.8)
actionpack (2.3.8)
activesupport (2.3.8)
builder (2.1.2)
commonwatir (1.6.5)
ffi (0.6.3 x86-mswin32)
firewatir (1.6.5)
fxri (0.3.7, 0.3.6)
fxruby (1.6.16 x86-mswin32-60)
hoe (2.6.1)
hpricot (0.8.2 x86-mswin32, 0.6.164 mswin32)
json_pure (1.4.6)
libxml-ruby (1.1.4 x86-mswin32-60)
log4r (1.1.8, 1.0.5)
mkrf (0.2.3)
nokogiri (1.4.3.1 x86-mswin32)
parseconfig (0.5.2, 0.4.2)
ptools (1.1.9, 1.1.6)
rack (1.2.1, 1.1.0)
rake (0.8.7, 0.8.1)
rmagick (2.12.0 mswin32)
roxml (3.1.5, 2.5.3)
ruby-oci8 (2.0.4 x86-mingw32)
ruby-opengl (0.60.0 i386-mswin32)
rubyforge (2.0.4)
rubygems-update (1.3.7)
s4t-utils (1.0.4)
test-unit (2.1.1, 2.0.1)
user-choices (1.1.6.1)
watir (1.6.5)
win32-api (1.4.6 x86-mswin32-60, 1.2.1 x86-mswin32-60, 1.2.0 x86-mswin32-60)
win32-clipboard (0.5.2, 0.4.4)
win32-dir (0.3.7, 0.3.2)
win32-eventlog (0.5.2, 0.5.0)
win32-file (0.6.5, 0.5.5)
win32-file-stat (1.3.4, 1.3.1)
win32-process (0.6.2, 0.5.9)
win32-sapi (0.1.5, 0.1.4)
win32-sound (0.4.2, 0.4.1)
win32ole-pp (1.2.0)
win32screenshot (0.0.7)
windows-api (0.4.0, 0.2.4)
windows-pr (1.0.9, 0.9.3)
xml-simple (1.0.12)
i try to install the oci8 by using this steps but it did not work
5) Install oci8 by -
i) Goto http://www.oracle.com/technology/software/tech/oci/instantclient/index.html, and download Instant Client Package - Basic, and Instant Client Package - SDK.
ii) Extract from the two downloaded zip files, and move
everything inside the two unzipped folders under one of the two
instantclient_11_1 (this is the version at the time of writing) folder,
which is
directly under the each of the two extracted folders.
iii) Goto C:\oracle, and if the oracle directory does not exist, create it under C:\.
iv) Place the instantclient_11_1 folder under C:\oracle.
v) Add instantclient_11_1 to the "Environmental Variables":
a) Right click on the "My Computer" icon
b) Left click on "Properties"
c) Left click on "Advanced"
d) Left click on "Environmental Variables"
e) Under "System Variables", double left click on the line starting with "Path"
f) At the end of the text box next to "Variable value", add -
;C:\oracle\instantclient_11_1
g) Click "OK"
h) Click "OK" under the "Environmental Variables" window
i) Click "OK" under the "System Properties" window
6) Install oci8 by typing into a command window:
gem install ruby-oci8
Note: Wait for the gem installation process to finish.
BUT
It shows me this error
C:\Documents and Settings\rajiv.nanduani>gem install ruby-oci8
Building native extensions. This could take a while...
ERROR: Error installing ruby-oci8:
ERROR: Failed to build gem native extension.
C:/Ruby/bin/ruby.exe extconf.rb
checking for load library path...
PATH...
checking C:\oracle\instantclient_11_1... yes
C:/oracle/instantclient_11_1/oci.dll looks like an instant client.
checking for cc... *** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.
Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby/bin/ruby
--with-instant-client
--without-instant-client
./oraconf.rb:562:in `check_cc': RuntimeError (RuntimeError)
from ./oraconf.rb:549:in `init'
from ./oraconf.rb:1001:in `initialize'
from ./oraconf.rb:343:in `new'
from ./oraconf.rb:343:in `get'
from extconf.rb:18
ng
---------------------------------------------------
Error Message:
C compiler doesn't work correctly.
Backtrace:
./oraconf.rb:562:in `check_cc'
./oraconf.rb:549:in `init'
./oraconf.rb:1001:in `initialize'
./oraconf.rb:343:in `new'
./oraconf.rb:343:in `get'
extconf.rb:18
---------------------------------------------------
See:
*
http://ruby-oci8.rubyforge.org/en/HowToInstall.html
*
http://ruby-oci8.rubyforge.org/en/ReportInstallProblem.htmlGem files will remain installed in C:/Ruby/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4 for in
Results logged to C:/Ruby/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4/ext/oci8/gem_make.out
error details of mkmf.log file
"cl -nologo -Feconftest -I. -IC:/Ruby/lib/ruby/1.8/i386-mswin32 -I. -IC:/Ruby/lib/ruby/1.8/i386-mswin32 -MD -Zi -O2b2xg- -G6 conftest.c msvcrt-ruby18-static.lib oldnames.lib user32.lib advapi32.lib shell32.lib ws2_32.lib -link -libpath:"." -libpath:"C:/Ruby/lib" -stack:0x2000000"
checked program was:
/* begin */
1: int main() { return 0; }
/* end */