Deployed sybase probe but it crashes and we cannot successfully configure a connection to the Sybase database server instance. Connection test threw an error ending in: ...The parameter %1! cannot be NULL
When configuring a connection, ensure that the name defined in the sql.ini file matches with the server name. The server name IS case sensitive. Use the same name when creating the connection to a Sybase instance using the sybase probe. To identify the instance name, check the sql.ini file on the Sybase ASE server.
To run the command from the cmd line on the local robot to confirm you can connect->
ISQL -S server -D database -U user -P password should work fine when executed to connect to the Server.
The sybase probe has the following prerequisites for installation.
1. Deselect Advanced Monitoring and Encryption since as of version 4.2 onward, the probe does not support Advanced monitoring using Monitoring Server. This is because the Monitoring Server is not a part of the Adaptive Server Enterprise version 15.7 and later.
Servername in the IM GUI for the sybase probe MUST be configured using the correct instance name (as per the sql.ini file on the Sybase Database Server) so that should be checked to confirm. No port was specified in the Server name field just the instance name.
2. In this particular case, once we edited the Sybase connection setup and specified the correct 'Server name' as the Sybase instance name (re-confirmed via the contents of the sql.ini file), then the connection test completed successfully.
Please review and double-check the probe requirements, e.g., hardware/software requirements,library path, configuration, etc.