similar to: slogging my way thru oracle, not adapter? gem install fails?

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

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

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, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a

I''ve a remote database create using Oracle. This database use schemas. I tried to connect to it using Ruby On Rails,with this file Database.yml : development: adapter: oci host: liber database: ENERGIA username: user password: pass test: adapter: oci host: liber database: ENERGIA username: user password: pass production: adapter: oci host: liber database:

I''m using the following configuration in the database.yml to connect to Oracle, however I could not connect while the settings seems to be correct: development_oracle: adapter: oci host: 127.0.0.1:8080/XE username: rubydb password: rubyrails What is wrong here? Can anyonbe help me? -- Posted via http://www.ruby-forum.com/.

I have a field that is a clob within an Oracle database on Rails 0.13. Things have been working well until I tried to submit the field empty via a rails app at which point the following error was returned: ORA-24801: illegal parameter value in OCI lob function /app/controllers/publications_controller.rb:64:in `update'' The line in question was: if

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

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 =

Hi! I'm trying to run a Windows Application that uses a Windows Oracle Client version. The GUI works ok, but when I login, the program gives me 'OCI.DLL: module not found'. Looking for something into winnedbg I noticed it calls OCI.DLL and loads ok, then start to load some libs, like SQLORA8.DLL, and so on.. until a DLL that it can't find and can't say me the name. Any hints?

I have written an Oracle Realtime Driver and a CDR Logger for Asterisk. The CDR logger works fine, but I think the realtime driver has problems in recognizing realtime extension patterns. I have written it in C++, because I used an OCI interface library (ORAPP). I want to post it opensource so that I could get help in its development and testing, and be a part of Asterisk modules.

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''m having a trouble when I try to connect RoR and Oracle. I believe that it has something to do with database.yml, this is how my database.yml looks: development: adapter: oci database: 127.0.0.1:1521/XE username: system password: y1984nip0359 host: 127.0.0.1 And this is the Error that i get: -> http://127.0.0.1:3000/blog OCIError in BlogController#index

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 have written the small script below. I have the ruby-oci adapter installed, the newest version of gems and the newest version of ActiveRecord. When I run the code I''m getting the follow error following my code. It seems to be an issue with gems as far as I can tell. Any help? Thanks, Drew Code: require ''ruby_gems'' require ''active_record''

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/.

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

ORA-12154: TNS:could not resolve the connect identifier specified I''ve updated rails to 2.0.2 and I start having a problem with oracle connection. I installed activerecord-oracle-adapter, and changed oci to oracle in database.yml but I keep getting the oracle error ORA-12154: TNS:could not resolve the connect identifier specified Can someone help me with this problem? Thanks. --

Hi, Normally I''m using Rails with mySql but for the moment I''m trying to make a Rails/Oracle solution using oci and instantclient, but I''m having a problem I receive the following when doing a select Exception string : undefined method `empty?'' for 1:Fixnum does anybody know a solution to this. kr Torben

Hi. I would like to hear how/what other users are installing for development and reference support. I currently have both InstantRails and the Ruby One-click Installer installed. I don''t like telling co-workers to install both (the OCI has lots of nice documentation useful to Rails developers). Also, the Ruby OCI helps when needing to run Ruby scripts outside of the InstantRails