Glen,
Look at the first DBI->connect line. Does it work without the
third line which connects to Postgress? How can you tell? You
did not check the return value from DBI->connect.
The trace seems to show an attempt to make a connection to
Postgress, but nothing to Ingres. I don't know about Ingres,
but shouldn't the first argument to connect begin with something
like "DBI:Ingres".
Try
use DBI;
$oDBase1 = DBI->connect( 'its-admin1::csadminp', '', '', 'Ingres' )
or die "Cannot connect to first database: " . $DBI::errstr;
$oDBase2 = DBI->connect('dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz',
'netdbase', '') or die "Cannot connect to second database: " . $DBI::errstr;
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.
>
> Tim.
>
> On Tue, Sep 24, 2002 at 08:18:49AM +1200, Glen Eustace wrote:
> > On Mon, 2002-09-23 at 21:24, Tim Bunce wrote:
> > > It should work fine - especially if using dynamic loading.
> > >
> > > Please create a small test program (three lines: 'use DBI;' and the
> > > two connects) then run it with the DBI_TRACE env var set to 9.
> > > See the DBI README file about how to get s stack trace from the core
> > > dump file. Post the script, the tracem and the stack trace.
> > -----------------------------
> > use DBI;
> > $oDBase1 = DBI->connect( 'its-admin1::csadminp', '', '', 'Ingres' );
> > $oDBase2 = DBI->connect(
> > 'dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz', 'netdbase', '');
> >
> > -----------------------------
> > dbx /usr/local/bin/perl core
> > dbx version 3.11.10
> > Type 'help' for help.
> > Core file created by program "perl"
> >
> > signal Segmentation fault at >*[__kill, 0x3ff800e9c28] beq r19,
> > 0x3ff800e9c40
> > (dbx) q
> >
> > -----------------------------
> > DBI 1.30-nothread dispatch trace level set to 9
> > Note: perl is running without the recommended perl -w option
> > <- connect= DBI::db=HASH(0x140169f28)
> > <- install_driver= DBI::dr=HASH(0x14016ac58)
> > -> connect for DBD::Pg::dr (DBI::dr=HASH(0x14016ac58)~0x140181e38
> > 'dbname=netdbase;host=its-dev2.massey.ac.nz' 'netd
> > base' **** HASH(0x140169e48))
> > New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x140181e38), id=)
> >
> > dbih_setup_handle(DBI::db=HASH(0x140181de8)=>DBI::db=HASH(0x140181d48),
> > DBD::Pg::db, 14016ac68, Null!)
> > dbih_make_com(DBI::dr=HASH(0x140181e38), DBD::Pg::db, 168) thr#0
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), Err,
> > DBI::dr=HASH(0x140181e38)) SCALAR(0x14018acb8) (already defined)
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), State,
> > DBI::dr=HASH(0x140181e38)) SCALAR(0x140169f18) (already defined)
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), Errstr,
> > DBI::dr=HASH(0x140181e38)) SCALAR(0x14018ace8) (already defined
> > )
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), Debug,
> > DBI::dr=HASH(0x140181e38)) 0 (already defined)
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), FetchHashKeyName,
> > DBI::dr=HASH(0x140181e38)) 'NAME' (already defined)
> > dbih_setup_attrib(DBI::db=HASH(0x140181d48), HandleError,
> > DBI::dr=HASH(0x140181e38)) undef (not defined)
> >
> > --
> > .*. | 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
> > ^^-^^ |------------------------------------------------------------
> >
--
James D. White ([EMAIL PROTECTED])
Department of Chemistry and Biochemistry
University of Oklahoma
620 Parrington Oval, Room 313
Norman, OK 73019-3051
Phone: (405) 325-4912, FAX: (405) 325-7762
