Configure the Oracle ODBC Driver

Having completed all the previous steps, you can now create an ODBC Datasource for your database.

This is done from either:

• the AQT Signon window > Add new Datasource
• the AQT Signon window > ODBC Manager > Add
• Windows search on ODBC > ODBC Datasources > Add

In all cases you will be shown the Oracle ODBC Driver Configuration dialog.

You only need to specify 2 things:

• Data Source Name. This is your name for the datasource. This can be any unique name
• TNS Service Name. You will have a dropdown list of the "Services" which have been defined in the tnsnames.ora file. Select the database you wish to connect to.

  If there are no entries in the dropdown list it means that the Oracle Client could not find your tnsnames.ora file. The most likely cause is that the TNS_ADMIN environment variable has not been set correctly.

Problems?

You may get a crash such as System Error code 14001. If this happens, the cause if that you have not installed the Visual Studio Redistributable.