You'll be presented to the ADO.NET provider download link, as well as how you can connect.
To connect to ADO.NET Provider you can follow instructions on the official ADO.NET Provider Documentation.
The ADO.NET Provider has a lot of connection string options that you can use to customize your JDBC 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.
- Auto-create: Allows to auto-create missing columns using the INSERT statement, using
You can find all the connection string options on the ADO.NET Provider documentation.
The driver supports the SQL-92 insertions and queries, so you can use pure SQL to make queries and insertions
using the ADO.NET provider.
Learn more about SQL compliance in other pages of this section.