Does SETSQLPROP( .... "PacketSize" ...) really work? I am seeing questions about that in the Hackers Guide, and I am pulling my hair out trying to get it to work for my SQL connections. I can do SETSQLPROP( 0, "PacketSize", 11264) with no problem. But I cannot do (get a -1 return value) trying SETSQLPROP( 1, "PacketSize", 11264). It seems that once the connection is made you cannot alter it? Does it matter that it's a saved connection?
I could use the improved performance this will afford us, but I am wondering if this is a mirage.
Any help is much appreciated.