db-drivers, list-db-drivers
The db-drivers or list-db-drivers command can be useful when you need to perform database data comparisons. It displays all ADO, ADO.NET, JDBC, and ODBC drivers detected on the local machine. The displayed driver information is INI-file friendly, in that it is in the syntax required for creating database connections in the server or client .ini configuration files. For more information, see Setting up Data Sources.
The output of the command is grouped in the following sections:
•ADO.NET: Displays all detected .NET providers.
•ADO: Displays all detected ADO providers.
•JDBC: Displays all JDBC drivers detected automatically from the CLASSPATH environment variable.
•ODBC: Displays all detected ODBC data source names (DSNs). These are the same data sources that are displayed when you run the ODBC Data Source Administrator (Odbcad32.exe). Note that the 32-bit version of the Odbcad32.exe file is in the C:\Windows\SysWoW64 directory. The 64-bit version of the Odbcad32.exe file is in the C:\Windows\System32 directory.
•Built-in: Displays those database connection methods that have built-in support in DiffDog Server and do not require drivers.
Note: Only drivers that correspond to the platform of DiffDog Server (64-bit or 32-bit) are listed. For example, if the currently installed Java Virtual Machine is 64-bit, the JDBC drivers will be detected only when the command is run by DiffDog Server 64-bit. The same is true for ODBC data source names (DSNs).
Syntax
diffdogserver db-drivers [options]
diffdogcmdlclient db-drivers [options]
Options
Specifies the path to a client configuration file where the details of the connection to DiffDog Server are defined
If you do not set the --c option, then diffdogcmdlclient attempts to read the client configuration file from the same directory as the executable. If there is no configuration file in the same directory, then the default values displayed by the showcfg CLI command and in the topic Client Configuration File are used.
|
Use this option to specify Java class paths in addition to any class paths that are already set in the CLASSPATH environment variable. The --extend-classpath option has the same usage and purpose as the extend-classpath parameter in the server or client configuration file.
|