On Tue, 2002-09-24 at 09:32, Tim Bunce wrote:
> Does it make a difference if you swap the order of connects?
>
> I probably can't help more without a stack trace.
I am not having much success at getting a Stack Trace.
perl -MDevel::CoreStack -e stack
Executing /usr/ucb/dbx "/usr/local/bin/perl" "core" (where)...
dbx version 3.11.10
Type 'help' for help.
Core file created by program "perl"
signal Segmentation fault at >*[., 0x3000182ad58] ldl r1,
16(r1)
0 (noname)() [0x3000182ad58]
/usr/ucb/dbx: fatal error: hit EOF on standard input file
It doesn't matter which order the connects are in.
They both work fine on their own. I am using each independently in other
scripts, I have one however that needs data from both database.
The segv occurs in the 2nd connect in both cases.
I have updated the dsn in the ingres connect, but the old way still
seems to work OK.
use DBI;
$oDBase2 =
DBI->connect('dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz',
'netdbase', '') or die "Cannot connect to second database: " .
$DBI::errstr;
$oDBase1 = DBI->connect( "DBI:Ingres:csadminp", 'dbguest', '',
{AutoCommit=>0})
or die "Cannot connect to first database: " . $DBI::errstr;
--
.*. | Glen Eustace, Systems Engineer - Networking.
/V\ | Information Technology Services PN460, Turitea,
(/ \) | Massey University, Palmerston North, New Zealand.
( ) | Ph: +64 6 350 5799 x 2707, Fax: +64 6 350 5607
^^-^^ |------------------------------------------------------------