confds (Database Toolbox)

Configure data source for Visual Query Builder (JDBC on UNIX only)

Syntax

```
confds
```

Description

confds displays the Configure Data Source dialog box, from which you add and remove data sources. Use confds only if you want to build and run queries using the Visual Query Builder via JDBC drivers on a UNIX platform. (You cannot use the Visual Query Builder on a Windows platform with a JDBC driver.) To add and remove data sources for connections that use ODBC drivers, see Setting Up a Data Source.

Complete the Name, Driver, and URL fields. For some data sources, the entry in Name must exactly match the name of the Data source. For example:

Name: orcl

Driver: oracle.jdbc.driver.OracleDriver

URL: jdbc:oracle:thin:@144.212.123.24:1822:

Click Add to add the data source.
Click Test to establish a test connection to the data source. You are prompted to supply a username and password if the database requires it.
Click OK to save the changes and close the Configure Data Source dialog box.

To remove a data source, select it, click Remove, and click OK.

Remarks

When using a JDBC connection (thin drivers) to an Oracle 10 database, do not specify the target name and port. For example, in the URL field of the Configure Data Source dialog box, specify only

```
jdbc:oracle:thin:
```

See Also
database (for examples of JDBC drivers and URLs)

commit crossreference