Extract DBI/DBD to where??

Fian has asked for the wisdom of the Perl Monks concerning the following question:

Once I have downloaded the DBD/DBI for NT I have to unzip it.

(I had to do this direct from CPAN as the ppm thing didn't work. It kept timing out.
I'm behind a corporate firewall so thats probably why.)

Must I save this data to the same drectory as my Perl Source?
At the moment the problem that I have been posting is that
when the script is run I get an error saying that it:

can't locate DBD/ODBC.pm in @INC (@INC contains: c:\bin\perl\lib c:\BIN\perl\site\lib

My directory structure is c:\bin\perl\lib (this is where I have ODBC.pm in the DBD-ODBC-0.28 sub-directory) and c:\bin\perl\site\lib (here I have a dbi and a dbd sub-directory, but no sign of ODBC.pm)

The actual code to access the database is fine, I can handle that, its just installing theses modules and getting the script to find them...

yours,
Losing the head in Belfast,
Fian....

Comment on Extract DBI/DBD to where?? Download Code

Replies are listed 'Best First'.
Re: Extract DBI/DBD to where?? by t0mas (Priest) on Mar 16, 2001 at 15:18 UTC
Did you try to set the environment variable HTTP_proxy before starting ppm? Like: `C:\> set HTTP_proxy=http://proxy.company.com:8080 C:\> ppm` [download] PPM (like all LWP programs) need it to pass through fire... /brother t0mas	[reply] [d/l]
Re: Extract DBI/DBD to where?? by Jouke (Curate) on Mar 16, 2001 at 14:48 UTC
If you can't download and install the package using PPM, you should go to the Activestate site and download the zipfile you need, unzip it on your harddisk, read the readme-file and follow their instructions. For me that has been the best way to install modules on Win32 platforms. Jouke Visser, Perl 'Adept'	[reply]
Re: Extract DBI/DBD to where?? by ColtsFoot (Chaplain) on Mar 16, 2001 at 15:20 UTC
Having just checked my ActiveState installation I find that ODBC.pm exists in d:\perl\site\lib\DBD The use DBD directive will check your @INC array for a directory containing the directory DBD so use DBD::ODBC will try to find ODBC.pm in d:\perl\site\lib\DBD	[reply]
Re: Extract DBI/DBD to where?? by dsb (Chaplain) on Mar 16, 2001 at 19:15 UTC
FYI: There is a tool with Active Perl called 'ppm'. If you use that it will download, and install most modules to the correct place. DBI/DBD is one of them(I used it for that). Here's how you run it: `c:\Perl>bin\ppm PPM interactive shell(2.1.2) - type 'help' for available commands PPM>install [modulename]` [download] Very convenient for the Windows environment. Hope that helps. But of course it won't since, you indicated that you already tried PPM and it didn't work. Sorry about that. I guess I should probably stop skimming entirely. I'm having this post deleted so please disregard it. Amel - f.k.a. - kel	[reply] [d/l]