Specifying the -z and -o database server options logs diagnostic communication messages, and other messages to the Database Server Messages window for troubleshooting purposes. On the client, adding the LogFile connection parameter to your connection string will log client side diagnostic communication messages to a file. These messages can help you diagnose how a connection is failing, what connection parameters are used for the connection attempt, and what communication links are being used.

 See also