Configuration #
This page provides instructions for creating and configuring a data source name
(DSN) using the Starburst ODBC driver v3 series.
Before you continue, you must install the driver.
Create a data source name #
To create a data source name (DSN):
- From the Windows Start menu, search for ODBC Data Sources and select
either ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit).
- Use the ODBC Data Source Administrator that matches your application’s
bitness. Verify the bitness by checking the title bar.
-
In the ODBC Data Source Administrator:

- Click the Drivers tab. Confirm that Starburst ODBC Driver appears
in the list.
- Choose either:
- User DSN tab (for a DSN only the current Windows user can access)
- System DSN tab (for a DSN all users on this machine can access)
- Click Add.
- In the Create New Data Source dialog, select Starburst ODBC Driver.
- Click Finish.

Connection settings #
In the ODBC Starburst Setup dialog, configure the following settings:
Proxy connection #
To configure a connection through a proxy server:
- In the ODBC Starburst Setup dialog, click Proxy Options.
- Select Use Proxy Server.
- Enter the Proxy Host (hostname or IP address).
- Enter the Proxy Port number.
- If necessary, enter Proxy User and Proxy Password.
- Optionally, in the Bypass proxy for domains/IPs field, enter a
comma-separated list of domains or IP addresses that do not require a proxy.
- The driver matches each entry as either a domain that contains the
hostname, or the hostname itself. For example,
sample.com
matches both
sample.com
and www.sample.com
, but it does not match sample.com.org
.
You can specify IP addresses using CIDR notation.
- To save your proxy settings, click OK.

Advanced options #
In the ODBC Starburst Setup dialog, click Advanced Options to configure
additional settings:
Testing your connection #
After configuring your basic settings:
- In the ODBC Starburst Setup dialog, click Test.
- If the test fails, review the error messages.
- When successful, click OK.
Logging options #
Enable logging to troubleshoot issues.
Note:
Logging settings are driver-wide and apply to all
connections, not just to a specific DSN.
To configure logging options:
- In the ODBC Starburst Setup dialog, click Logging Options.
- From the Log Level drop-down menu, choose from the following options:
- Off: Disables all logging
- Fatal: Logs severe error events that cause the driver to abort
- Error: Logs error events that allow the driver to continue running
- Warn: Logs events that may result in an error if you do not take action
- Info: Logs information that describes the driver’s progress
- Debug: Logs detailed information to use for debugging the driver
- Trace: Logs all driver activity
- In the Log Path field, select a folder to store log files.
- In the Max Number Files field, enter the maximum number of log files to
retain.
- In the Max File Size field, enter the maximum size of log files in
megabytes (MB).
- Click OK to save your settings.

Note:
Disable logging after you complete
troubleshooting. Extensive logging can impact driver performance and consume
disk space.
Is the information on this page helpful?