install DBD-Oracle on Windows XP using PPM : Microsoft, Windows XP, Active State PERL 5.10 and Oracle 9i

May 10, 2008 03:35pm pdt

1. Adam314 312,332
2. ozo 194,243
3. FishMonger 66,305
4. hielo 46,700
5. Tintin 45,565
6. mjcoyne 36,229
7. ravenpl 17,080
8. clockwat... 16,860
9. oleber 15,700
10. nixfreak 12,200
11. teraplane 11,500
12. ahoffmann 10,950
13. suhasbha... 10,100
14. kawas 8,300
15. sentner 7,780

1. ozo 3,466,008
2. Adam314 1,234,751
3. Tintin 693,859
4. kandura 579,965
5. jmcg 517,810
6. mjcoyne 488,367
7. FishMonger 418,939
8. maneshr 385,976
9. teraplane 355,708
10. manav_ma... 338,348
11. clockwat... 233,148
12. rj2 211,481
13. ahoffmann 196,513
14. davorg 153,165
15. Tim_Utschig 113,107

02.07.2008 at 09:36AM PST, ID: 23145154

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

install DBD-Oracle on Windows XP using PPM

Zones: Perl Programming Language, Oracle 9.x

Tags: Microsoft, Windows XP, Active State PERL 5.10 and Oracle 9i

Hi There,
I am attempting to install DBD-Oracle using ppm 4.0 on a Windows XP computer that has ActiveState version 5.10 installed. I could not do this successfully

These following are the attempts that I made to install the module:
1) Downloaded tar.gz file from CPAN and trying installing and landed into errors as I have no VC++.
2) Tried using PPM GUI interface to identify module and install but did not find the module
3) Tried using Cygwin to install and failed when ran "make"
4) Tried tweaking the make file to use MingW Compiler and landed into troubles.
5) In the command line typed
"ppm install DBD-Oracle"
"ppm install DBD::Oracle"
pm install failed: Can't find any package that provides DBD::Oracle

None of these work and results in the errors
Can anyone help me successfully install DBD::Oracle on Windows XP machine ?

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

           
           
             #Sample code for reference
use strict;
use warnings;
use diagnostics;
use DBI qw(:sql_types);            # Load the DBI module
 
my $dbh = DBI->connect( "dbi:Oracle:test", "test", "test123" )
or die("Couldn't connect to the database \n");
&main();
 
sub main()
{
  print "successfully connected\n";   
}
 
Error Message:
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: C:/Personal/packages/eclipse/eclipse/workspaces/.metadata/.plugins/org.epic.debug C:/Personal/packages/eclipse/eclipse/workspaces/TELENOR_v1.0 C:/Perl/site/lib C:/Perl/lib .) at (eval 16)[C:/Perl/lib/DBI.pm:750] line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: AnyData, CSV, DBM, ExampleP, File, Gofer, ODBC, Proxy, SQLRelay, SQLite, Sponge, Template, TemplateSS, XBase.
 at C:/Personal/packages/eclipse/eclipse/workspaces/TELENOR_v1.0/test.pl line 6
 at C:/Perl/lib/DBI.pm line 774
	DBI::install_driver('DBI', 'Oracle') called at C:/Perl/lib/DBI.pm line 620
	DBI::connect('DBI', 'dbi:Oracle:test', 'test', 'test123') called at C:/Personal/packages/eclipse/eclipse/workspaces/TELENOR_v1.0/test.pl line 6

           
         

Start your free trial to view this solution

Question Stats

Zone: Programming

Question Asked By: hSindhu

Solution Provided By: Adam314

Participating Experts: 2

Solution Grade: B

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

02.07.2008 at 09:57AM PST, ID: 20843115

Rank: Wizard

mjcoyne:

The Trouchelle repository has it. See http://trouchelle.com/perl/ppmrepview.pl?id=11510.

To add Trouchelle to your repositories, follow the instructions at http://trouchelle.com/perl/ppmrepview.pl.

Why are you using such an old version of Perl?

02.07.2008 at 12:40PM PST, ID: 20844880

hSindhu:

I am having the latest version of Active State PERL 5.10.0.
Tried installing the ones you told but had no luck. Tried installing as per the directions in the website and get this error. Any ideas?

C:\Personal\packages>ppm install http://trouchelle.com/ppm/DBD-Oracle.ppd
ppm install failed: The PPD does not provide code to install for this platform

02.07.2008 at 01:58PM PST, ID: 20845737

Rank: Genius

Adam314:

The version there is for perl 5.8. I'm guessing it'll work with perl 5.10, but can't test here.

If you want to try installing it anyways:
Download this file, and the attached file. save them to the same directory:
http://trouchelle.com/ppm/MSWin32-x86-multi-thread-5.8/DBD-Oracle-1.19.zip

Rename the attached file to DBD-Oracle.ppd (eg: remove the .txt extension, which is required for uploading at EE)

Go to a command prompt, and go the directory you downloaded those files
Enter this command: ppm install DBD-Oracle.ppd

DBD-Oracle.ppd.txt (563 bytes) (Possible File Type Mismatch)

The ppm installer file for DBD::Oracle (save using DBD-Oracle.ppd for the name)

02.07.2008 at 07:10PM PST, ID: 20847529

Rank: Wizard

mjcoyne:

Sorry -- for some reason, I read 5.10 as 5.01...:)

02.08.2008 at 10:04AM PST, ID: 20852454

hSindhu:

Hi Adam,

Thanks for sending the files. I still am having some problems. I installed the way you told and install went through fine. But when I tried using it in a small program this is what I get.

"The application has failed to start because perl58.dll was not found. Reinstalling the application may fix the problem".

I then fetched perl58.dll from TinyPerl application from the following website
http://tinyperl.sourceforge.net/
and placed it in C:\Perl\bin folder

When I ran through the simple program again I got a wierd message

"The procedure entry point Perl_Ilockhook_ptr could not be located in
the dynamic link library perl58.dll."

I am assuming that the problem was that the Activestate-Perl-DBI.pm does not work together with the DBD::Oracle from . In http://trouchelle.com/DBI/

Is it that I would need the DBI.ppd as well so that both can go together?

Do let me know how I can get out of this problem. I am totally struck with this problem.

Thanks

02.08.2008 at 10:45AM PST, ID: 20852798

Rank: Genius

Adam314:

The problem is that the DBI::Oracle module was designed for perl 5.8, and you have perl 5.10. This is what prevented the auto-installation. The instructions I gave were to allow you to try it anyway - but it isn't working.

You have a few options:
1) Install perl 5.8, and use the DBD::Oracle module at trouchelle
2) Find a pre-compiled DBD::Oracle module for perl version 5.10 (I don't know of one)
3) Compile the DBD::Oracle module for perl 5.10 yourself.

Option 1 is probably the easiest (unless you need perl 5.10 for some other reason). From the ActiveState website, it looks like the basic distribution includes both perl 5.8 and perl 5.10 - so you might already have perl 5.8 installed somewhere.

For option 3, you will need to install a compiler. I've never installed perl modules this way on a windows computer. If you have Microsoft Visual Studio, then that comes with a compiler. Otherwise, Microsoft has a free nmake program. After installing a compiler, you would install the DBD::Oracle module using CPAN:
(at a prompt) perl -MCPAN -e "install DBD::Oracle"

02.08.2008 at 11:27AM PST, ID: 20853169

hSindhu:

Adam,

I followed suggestion 1 and this is the what I get

ppm install DBD-Oracle.ppd
ppm install failed: The PPD does not provide code to install for this platform

As well when I look at the PPD file it seems like it is for Version 5.10 and not 5.8.8
<OS NAME="MSWin32" />
<ARCHITECTURE NAME="MSWin32-x86-multi-thread-5.10" />

Not sure though.

I too dont have VC++ and hence am looking for a pre compiled package.

Let me know if there are other options.

Thanks

02.08.2008 at 11:42AM PST, ID: 20853356

Rank: Genius

Adam314:

The PPD from trouchelle is for version 5.8. In the ppd I uploaded, I changed it to look as though it was for version 5.10. If you install directly from Trouchelle it will work, or in the attached PPD file, change it to version 5.8 (that's what it was originally)

To install directly from trouchelle, follow mjcoyne's instructions in post 20843115.
To install using the attached PPD: edit the PPD, changing 5.10 to 5.8. Install as you tried previously.

Accepted Solution

20080236-EE-VQP-29 / EE_QW_2_20070628