$dbh->{syb_flush_finish}=1; fixed the problem =)
- Original Message -
From: "Michael Peppler" <[EMAIL PROTECTED]>
To: "Jamie Orzechowski" <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 5:45 PM
Subject: Re: Script Hangs when executing ...
> Jam
Jamie Orzechowski writes:
> I just upgraded DBI to 1.15 and got the same error ... I have also tried
> this on a seperate box and gotten the same error ... are there any other DBD
> modules out there that can connect to MS SQL 7.0 databases??
Are you using the Sybase client or FreeTDS?
Michae
That would explain it. Thanks.
On Fri, 6 Apr 2001, Ronald J Kimball wrote:
> On Fri, Apr 06, 2001 at 03:03:30PM -0400, Curt Russell Crandall wrote:
> > It doesn't appear that this should happen, though, since $dbh is the
> > database handle ($dbh = DBI->connect()) and disconnect is called b
t;execute;
> $dbh->trace(9);
> $dbh->disconnect() or die("$DBI::errstr $DBI::err\n");
>
>
> - Original Message -----
> From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
> To: "Jamie Orzechowski" <[EMAIL PROTECTED]>
> Cc: <
On Fri, Apr 06, 2001 at 03:17:39PM -0400, Jamie Orzechowski wrote:
> Whoops ... Yes I am calling $dbh->disconnect ... I sent the script when I
> was trying out some things ...
>
Okay, that should fix the error message for the disconnect method. I'm
afraid I can't help with the problem of callin
riday, April 06, 2001 3:13 PM
Subject: Re: Script Hangs when executing ...
> On Fri, Apr 06, 2001 at 02:59:02PM -0400, Jamie Orzechowski wrote:
> > can you give me a quick snippet of code to disconnect on the database
> > object?
> >
>
> Instead of calling $sth->
On Fri, Apr 06, 2001 at 02:59:02PM -0400, Jamie Orzechowski wrote:
> can you give me a quick snippet of code to disconnect on the database
> object?
>
Instead of calling $sth->disconnect, you should call $dbh->disconnect.
(Assuming you've used those variable names. :)
Ronald
On Fri, Apr 06, 2001 at 03:03:30PM -0400, Curt Russell Crandall wrote:
> It doesn't appear that this should happen, though, since $dbh is the
> database handle ($dbh = DBI->connect()) and disconnect is called by
> $dbh->disconnect. From the code given, the DBI::st should not be
> complaining
ROTECTED]>
To: "Ronald J Kimball" <[EMAIL PROTECTED]>
Cc: "Jamie Orzechowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 3:03 PM
Subject: Re: Script Hangs when executing ...
> It doesn't appear that this should happen, th
It doesn't appear that this should happen, though, since $dbh is the
database handle ($dbh = DBI->connect()) and disconnect is called by
$dbh->disconnect. From the code given, the DBI::st should not be
complaining about this. This is an error similar to what I received a
while ago using Syba
th->execute;
$dbh->trace(9);
$dbh->disconnect() or die("$DBI::errstr $DBI::err\n");
- Original Message -
From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
To: "Jamie Orzechowski" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, Apri
t;[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 2:33 PM
Subject: Re: Script Hangs when executing ...
> On Fri, Apr 06, 2001 at 02:26:31PM -0400, Curt Russell Crandall wrote:
> > If Perl DBI is saying it can't find disconnect, then I would think
either
>
> Perl is saying
I don't know if this will help, but try changing
$dbh->disconnect || print "$DBI::errstr $DBI::err\n";
to
$dbh->disconnect() or die("$DBI::errstr $DBI::err\n");
I'm probably wrong, but if something is wrong with disconnect, but not
'die'ing, you might be causing it to hang on the print. Since
On Fri, Apr 06, 2001 at 02:26:31PM -0400, Curt Russell Crandall wrote:
> If Perl DBI is saying it can't find disconnect, then I would think either
Perl is saying that it can't find the disconnect method in the DBI::st
package. That's the statement handle package. The disconnect method
is in the
On Fri, Apr 06, 2001 at 02:13:17PM -0400, Jamie Orzechowski wrote:
> I tried sthX->finish and I get the same hangs ...
>
> I am split the script into seperate scripts and I run each part manually ...
>
> Even with the following script I get a hang ... if I insert sth->finish;
> then the script w
gt;disconnect || print "$DBI::errstr $DBI::err\n";
This Fails (hangs)...
$exec = qq{ Exec Subscribe_InsertPlan $custid,136,6,11,"$today"};
$sth2 = $dbh->prepare($exec);
$sth2->execute;
- Original Message -
From: "Curt Russell Crandall" <[EMAIL PR
"Hans Foght" <[EMAIL PROTECTED]>
> To: "'Thomas A. Lowery'" <[EMAIL PROTECTED]>; "Jamie Orzechowski"
> <[EMAIL PROTECTED]>
> Cc: "DBI-Users" <[EMAIL PROTECTED]>
> Sent: Friday, April 06, 2001 1:22 PM
> Subject: RE:
$sql);
$sth->execute || warn $sth->errstr;
$dbh->trace(9);
$dbh->disconnect;
- Original Message -
From: "Hans Foght" <[EMAIL PROTECTED]>
To: "'Thomas A. Lowery'" <[EMAIL PROTECTED]>; "Jamie Orzechowski"
<[EMAIL PROTECTED]>
Cc:
try $sthX->finish after execute when you do not need the $sthX anymore.
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
Sent: 6. april 2001 19:25
To: Jamie Orzechowski
Cc: DBI-Users
Subject: Re: Script Hangs when executing ...
Still just hangs after the l
L PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 06, 2001 12:55 PM
> Subject: Re: Script Hangs when executing ...
>
>
> > What does trace say? ($dbh->trace(1-9) just before the disconnect).
> >
> > Tom
> >
> > On Fri, Apr 06
What does trace say? ($dbh->trace(1-9) just before the disconnect).
Tom
On Fri, Apr 06, 2001 at 12:25:51PM -0400, Jamie Orzechowski wrote:
> Hello ... I have a script which connected to a MS SQL database ... it hangs
> right at the end of the script ... if I check my database it DOES insert all
21 matches
Mail list logo
