FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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