Skip to main content

Setting up ODBC drivers to view reports

How to set up ODBC drivers to view reports.

Emma Kelly avatar
Written by Emma Kelly
Updated over a month ago

Overview

⚠️Warning: If the machine is 32 bit machine create an ODBC driver through Data Sources in Administrative tools.
​

OR
​

If the machine is 64 bit then use the ODBC administrator in c:\windows\syswow64 folder (ODBCAD32.exe).

πŸ“ŒNote: You can find this out in the Systems settings of your settings application on your PC.


Once you have found that out, then you can follow these steps:

  1. Navigate to the system DSN tab. Click the Add button.

  2. Select SQL Server and click Finish.

  3. Enter a name for the data source (Typically DeltaWMS) and the Server on which Delta is installed.

  4. Ensure Windows NT Authentication is specified and check the β€˜Connect to SQL Server…’ option.

  5. Change the default database to the database for Delta (Typically DeltaWMS)

  6. Accept the defaults on the next page and click Finish.

  7. In the resulting window confirm the details entered and click β€˜Test Data Source…’

  8. The test should display as completing successfully.

πŸ€“Tip: For more information, please see Chapter 7, which can be found on Page 8 of the Delta Install Guide.doc

Did this answer your question?