Database

Contents

Store

Connection string
Enter a connection string for the target database, or click on the Variables button on the right, to select a variable which will contain the connection string.

You can either use the Get DSN button to list available system configured DSN or use the Wizard button to generate a new connection string.

Warning

Only 64bits system DSN are listed under the Get DSN function. Make sure to configure the DSN as a system DSN (not user) and under the 64bits ODBC Data Source Windows panel.

Query
Enter a target query to execute on the configured database, or click on the Variables button on the right, to select a variable which will contain the query or use variables dynamically inside the query.

Info

The query will be passed directly to the used provider, make sure to use SQL syntax which is valid for the selected provider.

Info

Parametrized variables can be inserted by using the @ symbol in front of the standard variable notation.

Create insert
Use this button to create a standard default INSERT SQL query placeholder clause.

Create update
Use this button to create a standard default UPDATE SQL query placeholder clause.

Info

Placeholder queries created via the Create Insert and Create Update buttons may not have the right syntax for all providers being defaulted, make sure the correct the syntax according the selected provider.

Wizard

Provider
Select here the provider (driver) to use to generate the target connection string. Drivers installed on the same Scanshare server are listed, by selecting an entry from the list the Properties section will be automatically populated with the specific driver properties.

Warning

Only 64bits drivers are listed in this list. Make sure to have the correct driver version installed.

Properties
Here all the specific selected driver properties will be listed, configure the needed properties according the type of connection to establish. For further information on the meaning of each property please refer to the selected driver documentation.

Previous Article

Data Output

Next Article

Djuma