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??
----- Original Message -----
From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
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, 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 Sybase and Perl 5.005_03/DBI 1.13... it was corrected by
> reinstalling at least DBI.
> If this is only a problem when calling a stored proc, then I'm lost. I
> know DBD::Sybase won't deal with calls to sp's with placeholders... this
> doesn't appear to be the problem here.
>
> On Fri, 6 Apr 2001, Ronald J Kimball wrote:
>
> > 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 DBI package.
> >
> > The solution is to call disconnect on the database handle object rather
> > than a statement handle object.
> >
> >
> > > $dbh somehow gets undef'd or maybe your disconnect method is
> > > missing. I've run into this before where my disconnect method was
> > > "missing". It may be you just need to reinstall DBI, which is what my
> > > sysadmin did. Why disconnect was missing... who knows??? It may also
be
> > > that we needed to reinstall the DBD::Sybase driver and possibly the db
> > > client libraries... it was a while ago and I do not remember.
> >
> > I'm afraid that these approaches would not solve this problem.
> >
> >
> > Ronald
> >
>
