Tips for SQL-Clients

From JDBWC Database Driver
Jump to: navigation

Setting up the Driver in SQL Clients

Its recommended to use "Database Type = Generic" when setting up the connection options. Generic will provide the best functionality. Not all SQL Clients have this option.

Make sure the quoted string character matches the actual database your connecting to.

If the SQL Client has a "Driver Properties" page you will be able to edit the connection properties for the Driver rather than trying to put them in a single URL string. Depending on the SQL Client you are using you may be presented with a list of all properties and there defaults or be able to enter properties into a blank list. If you get a blank list, see the Install guide for possible connection Properties and there values.