Connection to DB2

Hi,
I need some help in installing a DBI and DBD: Smiley Very Happy

B2 module on my TS server.
Intention is to connect a DB2-Database out of some iwperl-Scripts.

Environment:
TS 6.5 SP2
MS Windows 2003 SP1
DB2 Runtime Client installed
no internet connection available
no compiler tooles available

For some testing things, I installed an ActiveState Perl on another blank windows machine (no TS server...),
I downloaded the DBI and DBD: Smiley Very Happy

b2 module and installed them with ppm.
This was no problem, even without any installed compilers or available internet connections.

Now I'm trying to find out, what I have to do to get this stuff installed on my TS server.

If I'm wrong, please correct my, but iwperl uses cpan, not ppm for installation issues.
First step is the cpan configuration: cpan requests for an internet server, where it can download some files.
That's not possible in out environment.
Does anybody know how to go into an "offline" mode or something else?

Another problem is the need for some installed compiling tools.
Is there a chance to install these perlmodules without any installed compiling tools on my TS server?

Perhaps there're some completely different suggestions?

All suggestions are welcome.

Regards
Stefan

Find more posts tagged with

Comments

Adam Stoller

If you can identify (and locate) all of the files that were installed by PPM on your other server - you might be able to copy them into their respective place (within

iwhome/iw-perl/site/lib/...

) on your TS server and it might work.

stefanmaier

Hi Fish,
thanks for your suggestion. I tried to get all the files, but it also didn't work.
Problem was strange: Also a little perl script like

#!iwperl
use DBD:B2;
print "ok";

causes the iwperl.exe to crash without any error message or output.

That's the way I choose:
The installed DB2 Runtime Client provides an aditional ODBC driver.
This driver can easily used for the creation of an windows System-DSN (Start->Settings->Control Panel->Administrative Tools->Data Sources (ODBC))
If the System-DSN is created, it can be used in any perl scripts through

...
use DBI;
my $dbh = DBI->connect("DBIDBC:system_dsn_name", $db2user, $db2password);
...

Regards
Stefan

iwovGraduate

For the files you copied over, were those only Perl (.pm) files or did you have any binaries? If you had any binaries I doubt that it would work just by copying over all the files. Also is your iwperl version same as Active perl?

On your original post, you need internet connection to install CPAN modules only if you are using the "cpan" tools. I usually download the entire source and compile it manually.

IMHO getting the dev/compilation tools on your TS machine would be easier.