similar to: OCI/ODBC on Windows

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

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

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/

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

Am running centos5 , I want to compile my apache with php to support the following './configure' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-mysql=/usr/local/mysql' '--with-zlib-dir=/usr/lib/' '--enable-versioning' '--enable-track-vars=yes' '--enable-url-includes--enable-sysvshm=yes' '--enable-sysvsem=yes'

Hi, I'm trying to get OCI support in php on RHEL 4. So i installed the oracle-client and php.src.rpm and then typed: rpmbuild -bb --with oci /usr/src/redhat/SPECS/php.spec It rebuild fine, but no oci support, on the spec file of the PHP package it's there the OCI support, it's not --with oci that i should use? Thanks Regards, Ricardo -------------- next part -------------- An

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

I am attempting to connect to ORACLE11g however i am getting the following error: "OCI Library Initialization Error" IT always errors on OCIENV.init(). I cant see anything wrong on the ENV configurations. Has anyone had this problem, or any suggestions on where i should look for anwers? I am using the following gems: ruby-oci8 (1.0.4) activerecord-oracle-adapter (1.0.0.9250)

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 =

Is rails + oci8 + mac os x intel a winning combination? It appears that oci8 might be a issue.

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

My Application runs fine when run on webrick, but throws up database error when run from apache. this is the copy of the FULL TRACE i get /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `create'' /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `initialize'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in

Hello. Tired of searching and finding nothing useful. Moving application to laptop for trip. Installed: - Ruby (1.8.6, patchlevel 111) - Rails (2.2.2) - Oracle adapter (1.0.0.9250) - ruby-oci8 (2.0.1) - Oracle 10g Express Edition database.yml: development: adapter: oracle etc... When I start Mongrel (ruby script/server) I get the error above. I''ve looked everywhere I can think of.

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

Hi All, I have a problem in connecting to oracle and here is the steps i''ve been going through (i''m using the regular oracle8 client, not the instant one): 1. i installed the one-click ruby installer (ruby184-16p3 windows.exe) 2. i installed the rails-1.0.0 framework using gem successfully 3. i tried connecting to oracle using all possible combination in the database.yml file

Hi, Is anyone using Oracle with RoR successfully? Is everything running smoothly? What are the main issues? any response is appreciated thanks, Chris -- Posted via http://www.ruby-forum.com/.

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 I am a new to ROR and learning this framework from various tutorials. I have my new application and had the rails generate scaffold get going but after this when I first ran the rake db:migrate I got this ERROR! ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIError) I''m using database which is on a server and have used the tnsnames.ora

Hi, Environment: Solaris 10, Orale 10g, Apache 2.2, Ruby 1.8.4, Rails 1.2.3, Ruby OCI8 1.0.0-rc2 As soon as I compiled and installed the Ruby/OCI8 interface, I got the following error from my application: ========================= [notice] mod_fcgid: call /export/home/invido/invido/portal2/public/ dispatch.fcgi with wrapper /usr/local/bin/ruby /export/home/invido/

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for