ADO.NET Provider

You'll be presented to the ADO.NET provider download link, as well as how you can connect.


Download

Direct download link of the ADO.NET provider.


Connection

To connect to ADO.NET Provider you can follow instructions on the official ADO.NET Provider Documentation.

Connection Options

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 Other="EnforceTableSchema=false"

You can find all the connection string options on the ADO.NET Provider documentation.


SQL compliance

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.