ORA-12638 DBI->connect(nirvana) failed: ORA-12638: Credential retrieval
failed (DBD ERROR: OCIServerAttach)
Can anyone help me with the above error message? (Environment describe
below.)
I am trying to run this Perl script. MAOtestORA.pl
At this point I'm just trying to get the connect to work, not trying to do
anything with the data retrieved.
#!/usr/local/bin/perl
use DBI;
use CGI::Form;
use CGI::Carp qw(carpout);
carpout(STDOUT);
$dbh = DBI->connect("dbi:Oracle:nirvana", "system", "umntest") or
die "Cannot Connect";
my $sth = $dbh->prepare("SELECT * FROM NIRVANA.FORMUSER");
$sth->execute;
my @row;
@row = $sth->fetchrow_array();
print <<EOF
Content-Type: text/html
Cache-Control: max-age=120
<HTML>
<HEAD>
<TITLE>Connect to Oracle with CGI Example</TITLE>
</HEAD>
<BODY>
<H3>< B>Connecting to Oracle ...</B></H3>
</BODY>
</HTML>
EOF
I can run this script at the command prompt without a problem.
C:\Inetpub\wwwroot\cgi-bin\nirvana>MAOtestORA.pl
Content-Type: text/html
Cache-Control: max-age=120
<HTML>
<HEAD>
<TITLE>Connect to Oracle with CGI Example</TITLE>
</HEAD>
<BODY>
<H3>< B>Connecting to Oracle ...</B></H3>
</BODY>
</HTML>
C:\Inetpub\wwwroot\cgi-bin\nirvana>
I can link to other CGI-Perl scripts from a browser without a problem - as
long as they don't try to connect to Oracle
I can run SQL*Plus and SQL*Worksheet on this data base with this user/pwd
with no problem
Thank you
ENVIRONMENT (all on one box)
=========================
Windows 2000 5.00.2195 sp2
IIS 5.0
WWW Service settings
Home Directory settings
Execute Permissions: Scripts and Executables
Home Directory Configuration
C:\Perl\bin\perl.exe %s %s
.pl extenstion
limit to: GET, HEAD, POST
Oracle9i Database Release Notes
Release 1 (9.0.1.1.1) for Windows Platforms
Part Number A90161-01
Perl, v5.6.1 built for MSWin32-x86-multi-thread (with 1 registered patch,
see perl -V for more detail)
Copyright 1987-2001, Larry Wall
Binary build 631 provided by ActiveState Tool Corp.
http://www.ActiveSta
Built 17:16:22 Jan 2 2002
ppm> properties
====================
Package 1:
Name: DBI Version: 1.201
Author: Tim Bunce ([EMAIL PROTECTED])
Title: DBI
Abstract: Database independent interface for Perl
Available Platforms:
1. i686-linux-thread-multi
2. MSWin32-x86-multi-thread
3. sun4-solaris-thread-multi
====================
DBD
C:\Downloads\DBStuff\DBD\DBD-Oracle-1.12>nmake install
Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
Copyri ght (C) Microsoft Corp 1988-1998. All rights reserved.
Skipping C:\Perl\site\lib\auto\DBD\Oracle\mk.pm (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\dbdimp.h (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\ocitrace.h (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\Oracle.h (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\Oracle.lib (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\Oracle.exp (unchanged)
Skipping C:\Perl\site\lib\auto\DBD\Oracle\Oracle.bs (unchanged)
Skipping C:\Perl\site\lib\oraperl.ph (unchanged)
Skipping C:\Perl\site\lib\Oraperl.pm (unchanged)
Skipping C:\Perl\site\lib\DBD\Oracle.pm (unchanged)
Skipping C:\Perl\bin\ora_explain (unchanged)
Skipping C:\Perl\bin\ora_explain.bat (unchanged)
Writing C:\Perl\site\lib\auto\DBD\Oracle\.packlist
===========================================
Mark A Oklak, MBA, MCSD
Data Analyst / Manager
Research, Sponsored Programs, Graduate School
IUPUI.edu
620 Union Drive, Room 618
Indianapolis, IN 46202
317-278-2479
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
