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/

Reply via email to