 |
Forums |
Admin Discussion Forums: help Start New Thread
By: Luke Swihart
 RE: Connect to ISeries - noob question [ reply ]
2011-08-16 19:50
|
You should build the ibm_db client. To do this you will need the full db2 connect installation for iSeries as it is slightly different than the client for databases hosted on UNIX or Windows. IBM for some reason charges more for the iSeries client than other platforms.
One of the other folks in this thread made a good point, you should be able to speak to your IBM rep and request a "dev" client. I haven't heard of anyone building a iSeries db2 connect client or if connecting to db2 on iSeries via the ibm_db works or not. I would guess using jruby and the iseries jdbc driver would also be a viable solution.
-Luke
|
By: Karl Oakes
RE: Connect to ISeries - noob question [ reply ]
2011-01-28 08:35
|
|
Does anybody have any advice on connecting to the DB2 ISeries easily without using DB2 Connect as my shop will not pay for this. This is a real show stopper for me as I am currently investigating multiple server side technologies and need to recommend a new technology to an IT team. I have only just playing around with Ruby and love the dynamic nature of the language and the Rails framework, but our main DB is hosted on an ISeries and therefore this needs to be well supported, if not, Ruby will not be considered :( I am quite happy to try ODBC, but would like to use the Active Record feature ( maybe ODBC Data Adapter for Rails.). I am currently developing on a Windows box, should I be using a linux VM, would this help ? Any advice would be greatly appreciated.
|
By: Karl Oakes
RE: Connect to ISeries - noob question [ reply ]
2011-01-27 10:00
|
|
Thanks Praveen, we have never used DB2 connect and therefore we are not aware of the licenses. We have always connected using ISeries Access ODBC/.NET drivers. At the moment I am just trying to demonstrate that we can connect to the 400 with Ruby, if this needs to be with ODBC then so be it. As I said I am complete ruby noob and therefore any help with the DB2/Iseries connection would be greatly appreciated. For example,is it possible to use the Rails data adapter with the ODBC driver as I was would like to demonstrate some of the useful features that are built into Rails, i.e. Active Record.
|
By: Karl Oakes
RE: Connect to ISeries - noob question [ reply ]
2011-01-27 08:39
|
|
Thanks for the advice Praveen, I have heard about this DB2 connect license before in the .NET world, but I have never needed to investigate as I usually connect to the iSeries using an ISeries for Access ODBC driver or a .NET managed provider. Do you know the procedure for acquiring this license, will our shop be entitled to this since we have an ISeries or is it something we need to pay for. If we need to pay for it this will be a show stopper and I will probably need to connect via ODBC, which I was trying to avoid.
|
By: Karl Oakes
Connect to ISeries - noob question [ reply ]
2011-01-26 16:32
|
I am a complete noob with Ruby (using Windows 7) and I am trying to find the best way to connect to DB2 on the ISeries V5R3. I have installed the ibm_db-2.5.5-mswin32-rb191.gem, but when I use irb and insert the require 'mswin32/ibm_db' statement I get the following error message:
"Procedure entry point rb_str2cstr could not be located in dll msvcrt-ruby191.dll." I am completely confused and would appreciate some help as I would like to use Rails and it's Active Record pattern to map my tables/files on the ISeries to Models if possible. If not, do I need to resort to ODBC? I hope not :(
|
|
|
