similar to: Instant Client: Connecting Oracle and Mac

I had previously gotten Maik Schmidt''s patch for Oracle working, but now am trying the official Oracle adapter with the latest Rails. I''ve been trying to get the OCI8 connector to install under OS X, but get the following error. Has anyone gotten it working? ---- [waterdog:~/Desktop/ruby-oci8-0.1.9] stmpjmpr% ruby setup.rb config ---> lib ---> lib/DBD ---> lib/DBD/OCI8

My company''s System-admin installed Ruby and Gems (using Sun Coolstack package) and I have sudo access to ruby, gem etc. Now I need to get my app to talk to oracle db (through network). From what I understand, it requires three steps: Step 1: Install oracle instant client ( I installed it in my ~/oracle/ instantclient_11_1) Step2: Install OCI8 libraries (this is where I am stuck). Here is

Hello folks. I''m new in Ruby also ROR. I installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But its got some error. like this *custom_require.rb:36:in `require'': cannot load such file -- oci8 (LoadError)* my code is here. require ''oci8'' oci =

I''m trying to build the ruby-oci8 with the Oracle Instant Client on OS X. The Instant Client works, and the make seems to be ok with it up until OCIInitialize(). Anybody got this to work? [relevant output] /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby / Users/dmholmes/Desktop/ruby-oci8-1.0.0-rc2/ext/oci8/extconf.rb checking for load library path...

Hi, Does anyone know why gem can''t find activerecord-oracle-adapter? C:\>rails --version Rails 2.0.1 C:\>gem install activerecord-oracle-adapter ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord-oracle-adapter (> 0) in any repository It all started when I tried to run Mongrel on a Win32 box: C:\web\FDS_Server>mongrel_rails start

I''m trying to get ActiveRecord working with an Oracle DB over the instant client. On a 32bit machine, I can require ''oci8'': Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST 2009 i686 i686 i386 GNU/Linux irb(main):001:0> require ''oci8'' => true However, on a 64bit machine: Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue

Hi, I am getting the following error running my rails app: undefined method ''define_a_column'' for class OCI8:Cursor (NameError) Platform: Windows XP Rails: 1.0 ActiveRecord: 1.13.2 Oracle: 9.2 Ruby: 1.8.3 Oci Drive: ruby-oci8-0.1.13 Any clues ? Thank you all !! -- Posted via http://www.ruby-forum.com/.

I am trying to connect to an older oracle DB remotely, I think version 8 or 9. I downloaded the instant client stuff from oracle and copied oci.dll and oraociei10.dll to my windows/system folder (windows XP) I get the error. C:\rb-play>ar_connect_ss.rb env.c:257:in oci8lib.so: ORA-12514: TNS:listener does not currently know of serv ice requested in connect descriptor (OCIError) from

hi I have the latest rails version and would like to connect to an Oracle 9 database: this is my code: ========= ActiveRecord::Base.establish_connection( :adapter => "oci", :host => "host", :username => "user", :port => 1888, :password => "passwd", :database => "tmp1" ) class

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

Hi folks, Does anyone know how to install the OCI8 ruby interface on Debian64 without having to install Oracle? My understanding, from experience with Debian i386, is that you need Oracle (specifically the SQLPlus) installed to be able to compile OCI8. Since my new dev machine is AMD64 running Debian, I''m stuck. My rails applications need to connect to a remote Oracle 10g, but cannot

Hello, I''m trying to run rails on a Solaris 10 box with Ruby/OCI8, but I''m getting the following errors when trying to start up. # script/server => Booting WEBrick... /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/servers/ webrick.rb:49:in `[]='': failed to allocate memory (NoMemoryError) from /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/

Hello, I am trying to use R to download a bunch of .csv files such as: http://biocache.ala.org.au/ws/occurrences/download?q=Banksia+ericifolia I have tried the following and neither work: a<- getURL(" http://biocache.ala.org.au/ws/occurrences/download?q=Banksia+ericifolia") Error in curlPerform(curl = curl, .opts = opts, .encoding = .encoding) : embedded nul in string: and

Has anyone looked into having ActiveRecord use Oracle bind vars? I don''t know if the same concept is supported in other dbs, but Oracle''s OCI driver supports late binding with dramatically improved performance. I did a quick test to confirm that I could expect the same performance improvement through the Ruby OCI8 driver, and in a simple test it looks to be a 5x improvement.

Hi, After a few days of struggling, I was able to run this command successfully. ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/ xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}" I got "1.0" as output and I got my prompt back. So, I went back to the RoR app that I am working on,

Hello, Got Ruby 1.8.2, RAILS 1.0, Windows2kx and Ruby-OCI8.mswin (1.1.3) I try a migration test drive for one legacy DB from an original Ora win32 8.1.7 server to a better hardware running Win32 Oracle 9.2. The two DB have 99,999% identical datas. My rails app run on a independant serveur (W2003) using an Oracle Client 8.1.7. I''ve the same results using IIS/FastCgi or script/server

Howdy folks, Has anyone had any luck getting Oracle''s XMLType to play nicely with Rails? According to the docs, it''s just a wrapper around CLOB. However the ruby-oci8 driver throws an exception about user defined types if you try to query a table with an XMLType column. Any pointers would be appreciated. Thanks, -wilig

Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip

Hi! I have succesfully installed Oracle 9.2.0.4 on Centos. Everything is fine with it. Then I recompiled php-4.3.2-19.ent.src.rpm with rpmbuild --rebuild --define 'oracle 1' php-4.3.2-19.ent.src.rpm The compilation was successful, and I got the php and the php-oci8 rpms. Then I installed them both. After this one running the following PHP script: <?php $c =

Hi all, Ruby 1.8.4 Rails 1.1 OCI8 0.1.14 I think I''m hitting an issue with ActiveRecord::Base#save and the Oracle adapter. Line 158 in the schedules_controller.rb file is simply: 158: if @schedule.save 159: flash[:notice] = ''Schedule was successfully created.'' 160: redirect_to :action => ''list'' 161: else 162: render :action =>