Skip to Content.
Sympa Menu

freetds - Re: [freetds] DBD::Sybase 1.01 & FTDS 0.62-dev & temp tables

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DBD::Sybase 1.01 & FTDS 0.62-dev & temp tables
  • Date: Mon, 01 Dec 2003 17:27:31 -0800

I've read through the thread, and the only thing that I can think of is
that DBD::Sybase opens new connections for some reason.

You could check this by running with DBI->trace(3).

Michael

On Mon, 2003-12-01 at 11:42, Jerry Grooms wrote:
> Hello,
>
> I recently upgraded a platform from:
>
> HPUX 11.11
> perl 5.8
> DBD-Sybase-0.95
> freetds-0.53
>
> to:
>
> HPUX 11.11
> perl 5.8
> DBD-Sybase-1.01
> freetds-0.62-dev
>
>
> I had to upgrade from FTDS 0.61 to 0.62-dev due to the "queries that
> return 0 rows" bug; (kudos to the DBD::Sybase release notes)
>
> The above was corrected and things are mostly working except for
> previously working (unchanged) queries that utilize temporary
> tables. eg select blah,blah INTO #some_totals ...
>
> An example of what I'm seeing is:
>
> DBD::Sybase::st execute failed: Server message number=208
> severity=16 state=0 line=3 server=blah-blah text=Invalid object name
> '#proj_totals'. at ./topten_lastmonth.pl line 131.
>
> I've sifted through the release notes and archives and haven't found
> anything, yet.
>
> Are there any known issues with temp tables or should they work
> as before? I'll continue to debug.
>
> Thanks,
>
> Jerry
>
> ---
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html




Archive powered by MHonArc 2.6.24.

Top of Page