The PacketSize How do you know that definitely can be changed.
How do you now that new value is not used?
How do you establish the connection?
Do you have the latest SP installed on SQL 2000 (mskb #308016).

>
>Right, so what I've done is set the packetSize on connection 0 before any "real" connections are made, thinking that would then be used for the connections made after the SQLSETPROP( ) was called. That doesn't seem to be the case.
>
>So, it's sounding to me like packetSize cannot be altered from the 4096 default. Of course, I am hoping I am wrong and you will tell me what I am missing.
>
>Thanks.