FreeTDS Development Group

["Bort, Paul" <pbort AT tmwsystems.com>]

Just caught up on the thread. I can confirm that it is the protocol, our
developers using PowerBuilder under Windows (no FreeTDS at all) have the
exact same problem, and often open two or three concurrent connections to
get around it. 

In my Perl code, I don't have to worry about memory, so I tend to do a lot
of ->fetchall_arrayref and foreach to avoid nesting. Works great. 

I haven't tried it, but I can't think of a reason why you couldn't open two
different handles to the same database.

-----Original Message-----
From: Chad Wagner [mailto:vdr781 AT yahoo.com]
Sent: Friday, March 21, 2003 8:01 PM
To: FreeTDS Development Group
Subject: Re: [freetds] How well does FreeTDS scale?



--- "James K. Lowden" <jklowden AT schemamania.org>
wrote:
> Sorry to be so parochial, but if could you phrase
> the question in terms of
> ct-lib, I might be able to answer.  I googled
> "Nested statement handles"
> to:
> 
>
http://www.bitmechanic.com/mail-archives/dbi-users/Nov1998/0340.html
> 
> which left me unsure there's anything we can/should
> do.  
> 
> FreeTDS's ct-lib implementation has its
> deficiencies, but afaik we don't
> impose any serialism not already present in the
> protocol.  


It didn't appear to be limited to ctlib, as the ODBC
drivers seemed to have the same problem.  But the URL
you provided is what I was attempting to do.  It
returns a SQLExecute failure on the second (nested)
execute.


#!/usr/bin/perl

use DBI;

$dbh = DBI->connect('DBI:ODBC:DSN=mssql', 'sa', '',
   { RaiseError => 1, PrintError => 1, AutoCommit => 0
});

$st_a= $dbh->prepare("
   select \@\@version
");


$st_a->execute();

while (@data = $st_a->fetchrow_array()) {
   print "@data\n";

   $st_b = $dbh->prepare("
      select \@\@version
   ");
   $st_b->execute();
   while (@data = $st_b->fetchrow_array()) {
      print "@data\n";
   }
   $st_b->finish();
}

$st_a->finish();
$dbh->disconnect();



__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds