Accessing DB2 with DBD::DB2 on host

[mikrom]

Hello,
From my PC I need to access IBM DB2/UDB which is located on the host - the host is IBM iSeries (AS/400).
I can access it using ADO as I mentioned in my post here

http://www.tek-tips.com/viewthread.cfm?qid=1293279&page=1

but now I want to use DBI/DBD which is the standard in Perl.

I downloaded and installed DBD:B2. But when I try in my program

use DBD::DB2;

I get an error "This application has failed to start because DB2CLI.dll was not found."

Truly, there is not such a dll on my PC. I assume that this dll will be installed, when I would install DB2 on my PC. But I don't need DB2 on my PC, I need to access it on a remote AS/400.

My questions:

1) Is it not possible to use for this task DBD:B2?

2) Is DBD:B2 usable only whe my Perl-program would be on the same computer as my DB2 database?

3) Should I use any other DBD for example DBD::ODBC fo this task?

I'm newbie in Perl, please help me.

 

[stevexff]

DB2CLI.dll looks like the DB2 client dll. You should be able to install the client without the rest of DB2. Client code is usually free, too.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[mikrom]

Yes I have a client - IBM iSeries Access, but there is not DB2CLI.dll thereby