Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Alex Pitigoi
RE: Fial to load ibm_db 0.9.1 [ reply ]  
2007-11-26 13:52
Yes, that is likely the case, given that IBM_DB gem requires DB2 8 FP15 or DB2 9 FP2 and above (on Linux, Unix, Windows). The easy way from here is to download DB2 Driver for ODBC and CLI 9.1.2 available on-line (see link attached) and place its bin in the path (set PATH=D:\clidriver\bin;%PATH%, set LD_LIBRARY_PATH=D:\clidriver\lib).

Reference:
ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2_v91/clidriver/fp2/v9fp2_win_db2driver_for_odbc_cli.zip

By: zhang hong chen
RE: Fial to load ibm_db 0.9.1 [ reply ]  
2007-11-26 07:40
Hi Alex,

Thank you for your reminder. I have updated that list according to the document, but I just realized that my rails application has it's own copy of active_record.rb, I updated that file as well and the error disappeared! Hurray!!

I then try to test the connection and got this error. Is this because of my DB2 level not correct? Thanks!

D:\space\rails\tony>rake db:migrate
(in D:/space/rails/tony)
rake aborted!
Failed to connect to the [scrum] due to: [IBM][CLI Driver] CLI0133E Option type
out of range. SQLSTATE=HY092 SQLCODE=-99999

(See full trace by running task with --trace)

D:\space\rails\tony>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08023" with
level identifier "03040106".
Informational tokens are "DB2 v8.1.10.812", "s050811", "WR21362", and FixPak
"10".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

By: Alex Pitigoi
RE: Fial to load ibm_db 0.9.1 [ reply ]  
2007-11-23 12:59
Hi Zhang,

The exception showing "AdapterNotFound: database configuration specifies nonexistent ibm_db adapter" is signalling the need to register 'ibm_db' in the list of ActiveRecord adapters.

As mentioned before on previous threads, and IBM_DB documentation (on-line, see link below) and README, until Ruby 2 is out and dynamic loading of adapters is enabled, there's a need to manually add each supported adapter into the RAILS_CONNECTION_ADAPTERS list (line 77 in gems\activerecord-1.15.5\lib\active_record.rb).

Please let me know if this fixes your problem. Thanks.

Reference:
http://rubyforge.org/docman/view.php/2361/967/IBM_DB-0.6.0.pdf

By: zhang hong chen
Fial to load ibm_db 0.9.1 [ reply ]  
2007-11-23 09:27
Hi,

I'm new to rails. I spend the afternoon installing ibm_db driver and reading this forumn but still have no luck to bring up my first rails app on DB2. Here's what I've done. Did I miss anything? Thanks in advance!

Environment: I'm working on my thinkpad with WinXP OS

I installed ibm_db gem v0.9.1, when I run "gem list", I can see it in the long list.
ibm_db (0.9.1)
Rails Driver and Adapter for IBM Data Servers: {LUW, zOS, i5, IDS}

I went to my ruby application directory, run "ruby script\console", and got below error.

D:\space\railsapp\hellorails>ruby script\console
Loading development environment.
D:/space/railsapp/hellorails/vendor/rails/activerecord/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:210:in `establish_connection':
ActiveRecord::AdapterNotFound: database configuration specifies nonexistent ibm_
db adapter