Hi Michael;
That is a great question to which I have no SS experience in that aspect. However, I have used that feature via the Sybase ASE DBMS and it worked transparently to the PB Apps or IDE. ASE encrypts the server data & transmits it in the same fashion. However the native DB client (ie: SQLCA.DBMS = "ASE") decrypts the data stream (inbound to the PB App) and then hands that decrypted data stream over to the PB DB interface (PBASE.dll). So no changes to what the DB DB Client would normally see in a non-encrypted world.
The reverse happens on the outbound request as the PB DB Driver hands the non-encrypted data stream over to the ASE DB Client which then now encrypts the data stream on its way to ASE DBMS server.
I assume (hope) that MS-SS does it the same way. It will be interesting though to hear if any SS customers have used this SS feature and what their experiences were both functionally and performance wise. ;-)
Regards .. Chris