On Fri 13 Jul 2001 16:17, Michael Peppler <[EMAIL PROTECTED]> wrote:
> #!/usr/local/bin/perl -w
>
> use DBI;
>
> DBI->trace(3);
>
> $dbh = DBI->connect('dbi:Sybase:kiruna', 'sa', '');
>
> $dbh->disconnect;
can you see any difference when you narrow the scope?
--8<---
#!/usr/bin/perl -w
use strict;
use DBI;
DBI->trace (3);
{ my $dbh = DBI->connect ("dbi:Sybase:kiruna", "sa", "");
$dbh->disconnect;
}
-->8---
or if you explicitly destroy the handle?
--8<---
:
:
$dbh->disconnect;
undef $dbh;
-->8---
The same goes for statement handles:
--8<---
my $dbh = DBI->connect (...);
{ my $sth = $dbh->prepare ("select ...");
$sth->bind_columns (...);
while ($sth->fetch) {
:
}
}
-->8---
--
H.Merijn Brand Amsterdam Perl Mongers (http://www.amsterdam.pm.org/)
using perl-5.6.1, 5.7.1 & 628 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3,
WinNT 4, Win2K pro & WinCE 2.11 often with Tk800.022 &/| DBD-Unify
ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/H/HM/HMBRAND/