similar to: Problem with generating a scaffold with an Oracle DB

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

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, I am running the 64bit version of R on a AIX RS6000 cluster on which is also running the ' SQL*Plus: Release 9.2.0.2.0' in the 'ORACLE-environment Version 64 bit AIX 5.1'. I have problems setting up an Oralce database connection. I can instantiate a driver using drv <- Oracle(). But when I try to connect to my database using dbConnect (dbConnect(drv,

Hi My name i Lorenzo, I'm new on linux's world. I wold like to know is someone has tried to use Wine with Pro/Intralink (a PTC product). During installation...no problem. Lunching the program after installation... no results. Following, more informations: WINE Version: Wine 1.2-rc1 TERMINAL OUTPUT DURING INSTALLATION [code]icelolli at ascari:/media/PRO$ wine setup.exe icelolli at

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

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

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, 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

I searched this site on Oracle && MySql, nothing came up, so perhaps this is a new topic for this forum. I''d like to access two databases from the same application simultaneously (well, more precisely, in rapid succession, calling one first and then the other, as any "joins" will be done in the application code). One database is in MySql, the other is Oracle.

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not

i have rails-2.1.0 my database.yml development: adapter: oracle database: pe username: or password: or >rake db:create >rake db:version --->Current version: 0 >rake db:migrate rake aborted! ORA-12154: TNS:could not resolve the connect identifier specified (See full trace by running task with --trace) is above idea is possible, then how ? and i thing i should give service

Hello All, I know there is a component for integrating LDAP with Rails but is anyone doing any Windows Active Directory Authentication to a Rails app? I am rebuilding a site that was constructed out of asp and I would like to rebuild/improve it via rails. On the requirements side I will need to communicate with Active Directory and I will be required to use MSSQL for the database. Can anyone

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

Hi I run Ruby on Rails on Oracle XE. I have a simple table: create table customer(id number primary key, name varchar2(100)); And ruby script\generate model Customer ruby script\generate controller Customer http://localhost:3000/customer/ - show a fine list, but when I click show/edit/destroy, I get an ORA-01722: OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*,

I am a newbie Ruby and RoR user. In my tests using the turorials that I found over the web, everthing is working fine and I am very impressed about RoR framework. As I am a Delphi developer, without any web development experience, There is some thing hard to understando and I didn''t find a tutorial about this. I wonder how to create a non-scaffold page ? I have customers,

Thread-split from the vorbis-mailing list ("Vorbis determined to be as good as MPC at 128 kbps!") <p>On Sun, 30 May 2004, Segher Boessenkool wrote: [Steven So] SS>> If iTunes AAC can encode castanets with much less pre-echo at SS>> ABR 128 kbps, then hopefully there will be an imaginative SS>> (and non-patented) way of doing this in Vorbis without the SS>>

Hi! Sorry for the newbie question... I''m following the depot example in AgileWebDevelopmentWithRails. Stangelly, generating scaffolding using the command (page 53): ./script/generate scaffold Product Admin does not generate any .rhtml file, but just: exists app/controllers/ exists app/helpers/ exists app/views/admin exists test/functional/

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