There are two different solid.ini configuration files, one for the solidDB server and one for the ODBC client. Neither configuration file is required. If there is no configuration file, the factory values are used.
▪ The server-side solid.ini is used as the main configuration file for the server.
▪ The client-side solid.ini file is used with the solidDB ODBC client (driver) and the solidDB data management tools (solidDB SQL Editor (solsql) and so on).
If the solidDB server and the client are run on the same machine and use the same working directory, a single solid.ini configuration file can be both the server-side and the client-side configuration file. For example, the solid.ini configuration file in the soliddb_installation_directory\eval_kit\standalone directory contains both the server-side Com.Listen and the client-side Data Sources parameter settings.
Note In solidDB documentation, solid.ini usually refers to the server-side solid.ini file.
When the solidDB server (or ODBC client) is started, it attempts to open the configuration file solid.ini. If the file does not exist, the factory values for the parameters are used. If the file exists, but a value for a particular parameter is not set in the solid.ini file, factory value for that parameter is used. The factory values depend on the operating system you are using.
By default, the server (or client) looks for the solid.ini file in the current working directory.
You can specify the current working directory by using the -c solidDB command-line option, see Command line options, or by setting the SOLIDDIR environment variable, see Environment variables.
When searching for the solid.ini file, solidDB uses the following precedence in order:
▪ location specified with the -c solidDB command-line option (if used)
▪ location specified by the SOLIDDIR environment variable (if set)
▪ the directory from which solidDB (server or client) is started
The samples directory in the solidDB installation directory contains samples for different use cases. Each sample contains a solid.ini file with relevant settings for each use case; you can use the sample solid.ini files as a reference when configuring your environment.