I have perl installed under Windows 2000.
The following command works under SQLPLUS:
SQL> connect user/psswrd@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = srvr.domain.com)(PORT = 1521)))(CONNECT_DATA =
(SERVICE_NAME = db1dev.domain.com)))
Connected.
SQL>
However, connections attempted via DBD::Oracle yield "ORA-12538 (DBD
ERROR: OCIServerAttach)". I'm running this from a cgi on a local
installation of Apache.
I do set my oracle home, and the cgi runs otherwise.
$ENV{'ORACLE_HOME'} = "C:\oracle\ora81";
$dbh = DBI->connect('dbi:Oracle:', q{user/psswrd@(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = srvr.domain.com)(PORT
= 1521)))(CONNECT_DATA = (SERVICE_NAME = db1dev.domain.com))}, "");
Can anyone help? Thank you!
-Ian
P.S.
I successfully installed DBI and DBD::Oracle using ActiveState's
utilities:
C:\insdbi>ppm install DBI.ppd
Installing package 'DBI.ppd'...
Writing C:\Perl\site\lib\auto\DBI\.packlist
C:\insdbi>
C:\insdbd>ppm install DBD-Oracle8.ppd
Installing package 'DBD-Oracle8.ppd'...
Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll
Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.exp
Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.lib
Installing C:\Perl\site\lib\oraperl.ph
Installing C:\Perl\site\lib\Oraperl.pm
Installing C:\Perl\site\lib\DBD\Oracle.pm
Writing C:\Perl\site\lib\auto\DBD\Oracle8\.packlist
C:\insdbd>
