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 (in the DATABASE and the HOST entry) but failed with the nonexistent oci adapter (ActiveRecord::AdapterNotFound) exception, for example : - blank in DATABASE, full tns name entry in HOST, and vice versa - blank in HOST, sid name entry in DATABASE, and vice versa - both field with full tns name - both field with only sid name 4. so i tried re-installing only the activerecord (1.13.2) using gem and also the latest oci8 driver (ruby-oci8-0.1.14-mswin32.rb) again, but now everytime i tried to setup a new application, or start the webrick server : ruby script/server, an alert saying ''The procedure entry point OCILobClose could not be located in the dynamic link library OCI.dll'' occured. 5. Still hoping that other person encountered this problem, I googled and found some people said you have to make sure the ORACLE_HOME variable is set right, and also the ORACLE_HOME/bin is added to the PATH variable. So i tried that also but still the same error occured. 6. I googled again, and someone said, put the OCI.dll from your ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that again, but still the same error occured. 7. I posted this mail, hoping someone maybe have experienced the same problem like me and provide some solutions i can try... 8. to be continued... Thanks 4 your time, Yusuf.
On 3/16/06, Yusuf <Yusuf@ekalife.co.id> wrote:> 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 (in the DATABASE and the HOST entry) but failed with > the nonexistent oci adapter (ActiveRecord::AdapterNotFound) > exception, for example : > - blank in DATABASE, full tns name entry in HOST, and vice versa > - blank in HOST, sid name entry in DATABASE, and vice versa > - both field with full tns name > - both field with only sid name > 4. so i tried re-installing only the activerecord (1.13.2) using gem and > also the latest oci8 driver (ruby-oci8-0.1.14-mswin32.rb) again, but now > everytime i tried to setup a new application, or start the webrick > server : ruby script/server, an alert saying ''The procedure entry point > OCILobClose could not be located in the dynamic link library OCI.dll'' > occured. > 5. Still hoping that other person encountered this problem, I googled > and found some people said you have to make sure the ORACLE_HOME > variable is set right, and also the ORACLE_HOME/bin is added to the PATH > variable. So i tried that also but still the same error occured. > 6. I googled again, and someone said, put the OCI.dll from your > ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that > again, but still the same error occured. > 7. I posted this mail, hoping someone maybe have experienced the same > problem like me and provide some solutions i can try... > 8. to be continued...I think you need to install the Oracle DBI driver. You can read all about DBI drivers here (search the page for Oracle): http://ruby-dbi.rubyforge.org/ Curt
On 3/16/06, Yusuf <Yusuf@ekalife.co.id> wrote:> 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): > > 4. so i tried re-installing only the activerecord (1.13.2) using gem and > also the latest oci8 driver (ruby-oci8-0.1.14-mswin32.rb) again, but now > everytime i tried to setup a new application, or start the webrick > server : ruby script/server, an alert saying ''The procedure entry point > OCILobClose could not be located in the dynamic link library OCI.dll'' > occured. > 5. Still hoping that other person encountered this problem, I googled > and found some people said you have to make sure the ORACLE_HOME > variable is set right, and also the ORACLE_HOME/bin is added to the PATH > variable. So i tried that also but still the same error occured. > 6. I googled again, and someone said, put the OCI.dll from your > ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that > again, but still the same error occured.Are you using the latest version of 8i, or something older like 8.0.5? Someone on this list had a very similar problem a few months ago, and I seem to recall it being solved by updating to a newer 8i client. If all else fails, the InstantClient works very nicely. Heh.
Hi, and thanks for the feedback,>I think you need to install the Oracle DBI driver. You can read all >about DBI drivers here (search the page for Oracle): > > http://ruby-dbi.rubyforge.org/ > >CurtOkay I will try this driver and post the results again in here :)>Are you using the latest version of 8i, or something older like 8.0.5? > Someone on this list had a very similar problem a few months ago, and >I seem to recall it being solved by updating to a newer 8i client. If >all else fails, the InstantClient works very nicely. Heh.Yes I think I''m using the older version, guess I will try the first solution by Curt, and if it still failed, guess I have to update the client :) Thanks, Yusuf