similar to: oracle_enhanced problem connection

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, Can any one help me? I''m using Ubuntu and trying to connect to an oracle database using oracle_enhanced adapter connection, but keeps getting following error: /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies. rb:275:in `load_missing_constant'': uninitialized constant ActiveRecord::Connecti onAdapters::OracleEnhancedAdapter (NameError)

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

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)

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,

i''m working on ubuntu 11.04; i need to create some rails application with oracle database on local computer. i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6, gem ''activerecord-oracle_enhanced-adapter'', create database user named ''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked new application

Hi, when I configure my app to use the oracle_enhanced adapter it throws the following exception: java.sql.SQLException: ORA-01882 : Timezone region not found How can I solve this? Thanks, Rafael Roque -- Posted via http://www.ruby-forum.com/.

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

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

Hi, My setup is: Ruby 1.8.6 Rails 2.3.5 activerecord-oracle-adapter (1.0.0.9250) I upgraded Rails and the adapter recently and I just went through hell trying to find a problem while inserting a record in a table. Rails was giving me this error: OCIError (ORA-02289: sequence does not exist): stmt.c:539:in oci8lib.so c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:753:in `exec''

I have a form ... html ..... <% form_for @person do |f| %> ... html ..... <%= f.text_field :last_name %> ... html ..... <% end %> When last_name field of @person doesn''t contains french special symbols like ''é'', all characters are displayed in the input control (f.text_field :last_name ). Else only symbols before french special symbol are

We''re trying to deploy our system on a separate server and have run into nothing but trouble; specifically I get the error mentioned in the subject. The username/password combo is correct (I verified it via SQL+). Manually running script/server works fine in production or development mode. Heck, running script/console also works fine. It''s just that when it automatically

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.

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

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

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

Hi, I have some problems with rails and the oracle_enhanced adapter. My rails application is working but not my rake task. It doesn''t find the oracle_enhanced adapter. Please install the oracle_enhanced adapter: `gem install activerecord-oracle_enhanced-adapter` (no such file to load -- active_record/connection_adapters/oracle_enhanced_adapter) But the gem is installed as the rails

Hi, I''m able to run a ROR application in a Red Hat Enterprise Linux 4.4 environment, as long as I start my mongrel_cluster via the command line: [chris at localhost ~]$ mongrel_cluster_ctl start I take a look at the two mongrel_rails processes that were just created: [chris at localhost log]$ ps -ef | grep mongrel chris 4781 1 5 05:55 ? 00:00:02 /usr/local/bin/ruby

Hi all, I''ve got a rather complex problem on my hands. I''m using Leopard (OSX 10.5) on an Intel Mac, with the standard Ruby and Rails installations. In order to get Rails to talk to Oracle, I upgraded the Rails gems to the latest release candidate (1.99), and installed the oracle adapter gem. So far so good. But the Oracle InstantClient is a PPC-only library. You