Your connection string does notappear to be DBI friendly. You might want
to try something like this:
$ENV{"ORACLE_HOME"}="/path/to/your/oracle/home";
$dbh=DBI->connect("DBI:Oracle:host=oraclehost.yourdomain.com;sid=database","username","password");
that connect string works for under activestate's 5.6.1 for win 32 and
my 5.6.1 under linux. you also may want to check out Mr. Bunce's ORA
book _Programming the Perl DBI_ http://www.oreilly.com/catalog/perldbi/
hope that helps
On Thu, 2003-02-27 at 20:55, Ian Jones wrote:
> 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))}, "");
> --rest trimmed
--
David Crown, MCSE, MCP+I, CCNA
Office of Information Technology
State of Delaware,
Department of Natural Resources and Environmental Control
[EMAIL PROTECTED]
Voice: (302)739-4409 Fax: (302)739-6242
www.dnrec.state.de.us/
