On Tue, 16 Apr 2002, Stefan Mueller wrote: ... > http:[EMAIL PROTECTED]/msg08989.html > > But I don't understand that code. How can I use multiple statements if > sql server doesn't support it? > > > > $dbh->{odbc_SQL_ROWSET_SIZE} = 2; # Any value > 1 > > I only add this line to my code and I can use nested sql statements. :-)
hmm. limitation of TDS? back in the day when i was playing with Sybase, it turned out that Sybase couldn't handle multiple executing queries on a single connection. the workaround implemented by DBD::Sybase was to open a new connection automagically if a nested SQL was detected. maybe this problem "migrated" to M$? and that's their fix? --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc.
