Perl weenie needed

  • Two Factor Authentication is now available on BeyondUnreal Forums. To configure it, visit your Profile and look for the "Two Step Verification" option on the left side. We can send codes via email (may be slower) or you can set up any TOTP Authenticator app on your phone (Authy, Google Authenticator, etc) to deliver codes. It is highly recommended that you configure this to keep your account safe.
Mute

Mute

All you have to do is smile!
Dec 20, 1999
2,478
3
38
The Hub^H^H^H Armpit of the Universe
Visit site
technically speaking yes, but it's very difficult and doesn't always seem to work correctly in widows, which is why ppm was created in the first place. That error is the generic error one gets when there is no such package on CPAN, but i know it exists... here i try to install a fake package (franfkel) and then verify that my DBI is up to date:

Code: 
v:\>ppm
PPM interactive shell (2.1.5) - type 'help' for available commands.
PPM> install franfkel
Install package 'franfkel?' (y/N): y
Installing package 'franfkel'...
Error installing package 'franfkel': Could not locate a PPD file for package franfkel
PPM> install DBI
Version 1.14 of 'DBI' is already installed.
Remove it, or use 'verify --upgrade DBI'.
PPM> verify --upgrade DBI
Upgrade package 'DBI'? (y/N): y
Package 'DBI' is up to date.
PPM>

To install the package by hand on your PC you have to do something of the following: download the DBI package from CPAN yourself, get some kind of C compiler for windows that has 'make' functionality (nmake?), compile it and install it- which may or may not work (because make and the source packages on CPAN are intended for unix), and if it doesn't you'll need a C++ uber-weenie to figure out why.
 
Mute

Mute

All you have to do is smile!
Dec 20, 1999
2,478
3
38
The Hub^H^H^H Armpit of the Universe
Visit site
It should be as simple as this (i'm removing and installing both the Database Interface and the Oracle Database Driver on my PC):

Code: 
v:\>ppm
PPM interactive shell (2.1.5) - type 'help' for available commands.
PPM> remove DBD-Oracle
Remove package 'DBD-Oracle?' (y/N): y
PPM> remove DBI
Remove package 'DBI?' (y/N): y
PPM> install DBI
Install package 'DBI?' (y/N): y
Installing package 'DBI'...
Bytes transferred: 243541
Installing D:\Perl\site\lib\auto\DBI\dbd_xsh.h
Installing D:\Perl\site\lib\auto\DBI\DBI.bs
Installing D:\Perl\site\lib\auto\DBI\DBI.dll
Installing D:\Perl\site\lib\auto\DBI\DBI.exp
Installing D:\Perl\site\lib\auto\DBI\DBI.lib
Installing D:\Perl\site\lib\auto\DBI\dbipport.h
Installing D:\Perl\site\lib\auto\DBI\DBIXS.h
Installing D:\Perl\site\lib\auto\DBI\dbi_sql.h
Installing D:\Perl\site\lib\auto\DBI\Driver.xst
Installing D:\Perl\html\site\lib\DBI.html
Installing D:\Perl\html\site\lib\Win32\DBIODBC.html
Installing D:\Perl\html\site\lib\DBI\DBD.html
Installing D:\Perl\html\site\lib\DBI\FAQ.html
Installing D:\Perl\html\site\lib\DBI\Format.html
Installing D:\Perl\html\site\lib\DBI\ProxyServer.html
Installing D:\Perl\html\site\lib\DBI\Shell.html
Installing D:\Perl\html\site\lib\DBI\W32ODBC.html
Installing D:\Perl\html\site\lib\DBD\ADO.html
Installing D:\Perl\html\site\lib\DBD\Multiplex.html
Installing D:\Perl\html\site\lib\DBD\Proxy.html
Installing D:\Perl\html\site\lib\Bundle\DBI.html
Installing D:\Perl\site\lib\DBI.pm
Installing D:\Perl\site\lib\Win32\DBIODBC.pm
Installing D:\Perl\site\lib\DBI\DBD.pm
Installing D:\Perl\site\lib\DBI\FAQ.pm
Installing D:\Perl\site\lib\DBI\Format.pm
Installing D:\Perl\site\lib\DBI\ProxyServer.pm
Installing D:\Perl\site\lib\DBI\Shell.pm
Installing D:\Perl\site\lib\DBI\W32ODBC.pm
Installing D:\Perl\site\lib\DBD\ADO.pm
Installing D:\Perl\site\lib\DBD\ExampleP.pm
Installing D:\Perl\site\lib\DBD\Multiplex.pm
Installing D:\Perl\site\lib\DBD\NullP.pm
Installing D:\Perl\site\lib\DBD\Proxy.pm
Installing D:\Perl\site\lib\DBD\Sponge.pm
Installing D:\Perl\site\lib\Bundle\DBI.pm
Installing D:\Perl\bin\dbiproxy
Installing D:\Perl\bin\dbiproxy.bat
Installing D:\Perl\bin\dbish
Installing D:\Perl\bin\dbish.bat
Writing D:\Perl\site\lib\auto\DBI\.packlist
PPM> install DBD-Oracle
Install package 'DBD-Oracle?' (y/N): y
Installing package 'DBD-Oracle'...
Bytes transferred: 92963
Installing D:\Perl\site\lib\auto\DBD\Oracle\Oracle.bs
Installing D:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll
Installing D:\Perl\site\lib\auto\DBD\Oracle\Oracle.exp
Installing D:\Perl\site\lib\auto\DBD\Oracle\Oracle.lib
Installing D:\Perl\html\site\lib\Oraperl.html
Installing D:\Perl\html\site\lib\DBD\Oracle.html
Installing D:\Perl\site\lib\oraperl.ph
Installing D:\Perl\site\lib\Oraperl.pm
Installing D:\Perl\site\lib\DBD\Oracle.pm
Installing D:\Perl\bin\ora_explain
Installing D:\Perl\bin\ora_explain.bat
Writing D:\Perl\site\lib\auto\DBD\Oracle\.packlist
PPM>

I could try to winzip up all the files and send them too you, but i'm not certain if it as simple as that- there might be registry issues... in unix it would be as simple as making the DBI directory and throwing the files in it so you might be able to get away with it!
 
Mute

Mute

All you have to do is smile!
Dec 20, 1999
2,478
3
38
The Hub^H^H^H Armpit of the Universe
Visit site
Hey there... here's the file and file-list (00_FILE_LIST.txt). I've totally coopted the board system to get this to you, but you don't have a published email or pm (which makes sense around here :p). Sorry moderators! it won't happen again!

Just grab the attachment, rename if from dbi.zip.bmp to dbi.zip and try dropping all the files in the correct locations to see if it works. Hmm... but i take no responsability if your computer crashes, catches on fire and melts down afterward ;).

ppm is still the prefered method, if you can get it to work, of course!
 
Sapphire Nights

Sapphire Nights

BANNED
Feb 4, 2000
3,281
0
0
Visit site
Hey! You sent me p0rn! Not really... :D

I installed it as you said. But when I run the script I get an error "Can't locat DBD/ODBC.pm" Perhaps the DBD::ODBC perrl modual hasn;t been fully installed. So I assume by this thge install needs to make reg and ODBC settings :hmm:
 
Mute

Mute

All you have to do is smile!
Dec 20, 1999
2,478
3
38
The Hub^H^H^H Armpit of the Universe
Visit site
Ah! we can work with this. DBD-OBDC is a specific Database Driver that you need (as opposed to DBD-Oracle that I normally use). I installed it on my pc and bundled all the files in another zip file for you. use this to figure out where all the files should go:

Code: 
C:\>ppm
PPM interactive shell (2.1.5) - type 'help' for available commands.
PPM> install DBD-ODBC
Install package 'DBD-ODBC?' (y/N): y
Installing package 'DBD-ODBC'...
Bytes transferred: 35966
Installing D:\Perl\site\lib\auto\DBD\ODBC\ODBC.bs
Installing D:\Perl\site\lib\auto\DBD\ODBC\ODBC.dll
Installing D:\Perl\site\lib\auto\DBD\ODBC\ODBC.exp
Installing D:\Perl\site\lib\auto\DBD\ODBC\ODBC.lib
Installing D:\Perl\html\site\lib\DBD\ODBC.html
Installing D:\Perl\site\lib\DBD\ODBC.pm
Writing D:\Perl\site\lib\auto\DBD\ODBC\.packlist
PPM>
 
Sapphire Nights

Sapphire Nights

BANNED
Feb 4, 2000
3,281
0
0
Visit site
ThX Mute :)

I ended up finding the original perl scripts that did not use the DBI but flat files instead. Some idiot contractor put that stuff in to impress my boss. Your don't need a fancy database for a table with one column and 200 rows. :rolleyes:
 
You must log in or register to reply here.
Top Bottom