You can download the SlicingDice ODBC driver by clicking on this link.
To connect to the ODBC Driver you can follow the instructions for your operating system on the official ODBC documentation.
The ODBC driver has a lot of connection string options that you can use to customize your ODBC experience, below you can find the most important ones.
- Logfile - The path to the log file, with the log file you can find the translations made by the driver and debug if any error occur;
- Verbosity - The log verbosity, you can set a value between 1 and 5 where 1 is the lower verbosity and 5 the higher.
You can find all the connection string options on the ODBC Driver documentation.
Use EnforceTableSchema to auto-create columns
The ODBC driver allows the user to auto-create missing columns using the INSERT statement, to do so you will need to add the following connection string when loading the driver:
The SlicingDice supports the SQL-92 insertions and queries so you can use the pure SQL to make queries and insertions using our driver. To learn more about the SQL compliance you can check the driver documentation.
|ADO.net SQL Driver|