Troubleshooting the Packet Size on Sybase ASE

Problem:

On Sybase ASE, you may receive the following error:

The packet size (4096) specified at login time is illegal. Legal values are between 512 and 512.

Solution #1:

Run the following command at the SQL prompt:

sp_configure “additional network memory”, 251904

go

sp_configure “max network packet size”, 8192

go

Solution #2:

An alternate solution is to set the NN_SYB_PACKETSIZE environment variable to the desired size. The ASE server default is 512.