Re: Connection prob w/DBD Oracle, Activestate 5.6.1, NT 4

2003-04-06 Thread Michael A Chase
On Fri, 4 Apr 2003 11:43:11 -0800 (PST) John Costello <[EMAIL PROTECTED]> wrote: > The script is: > use DBI; > > $port = "1521"; > $host = "myserver.mydomain.com"; > $sid = "LYST"; > $user = $passwd = "reporter"; > $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=$port", $user, > $passwd

Re: Connection prob w/DBD Oracle, Activestate 5.6.1, NT 4

2003-04-04 Thread John Costello
The problem turned out to be an NT registry problem and a script error. At some point, Oracle 8.1.6 was installed, and the registry's entry for ORACLE_HOME is "d:\ora816". Oracle is installed in D:\ora817, and there is no d:\ora816. I found this courtesy of the DBI->trace(). Compounding the

Connection prob w/DBD Oracle, Activestate 5.6.1, NT 4

2003-04-04 Thread John Costello
Not sure if this is an Oracle issue, NT issue, or DBD issue. I'm using Activestate 5.6.1 633 with DBI 1.34 and DBD::Oracle 1.12. I have a dbh connect command that works fine on two systems, but not the system that servers the database. (One client is W2K, one is NT 4; the database server is N