In this case, the required behavior can be explicitly specified in the Connection String by setting the ODBC Behavior parameter. But some third-party tools expect the driver to exhibit ODBC 2.x behavior, but forget to call SQLSetEnvAttr with the specified version or pass an incorrect value there. The behavior of ODBC driver can be changed by setting a value for the SQL_ATTR_ODBC_VERSION attribute by calling the SQLSetEnvAttr function. Used to set the behavior corresponding to the ODBC specification version that a third-party tool expects. These options should be enabled for compatibility with such tools. But some 3rd-party tools pass NULL to the parameters. If NULL, the driver should return an error. To retrieve metadata, not all parameters according to MSDN can accept a null value. See official MongoDB documentation for a full description of these options. Each server has to be specified in the host format as it is described in the official MongoDB documentation.Ĭonnection specific options. Specifies additional servers to connect to, separated by commas. Specifies the number of sample documents used to create a list of fields in the dataset. If True, it will be presented in lowercase. If False (default), then ObjectId will be presented in uppercase. If False, such fields are mapped as a set of their child fields. If True, then complex fields of a document (which are of object, array, timestamp, binary, regular expression or JavaScript type) are mapped as a single string field and their content is displayed in the Extended JSON format. If True, then when editing an existing document, it allows to add new fields to the document. Used to specify the libbson client library location. Used to specify the libmongoc client library location.

Used to supply a unique User ID for login. Used to specify the port number for the connection. Serves to supply the server name for login. The following table lists the connection string options for MongoDB.

Mongo connect string