Setting Up a Data Source Name

This section describes how to set up an ODBC data source name using the Vertica ODBC Driver. It assumes that the driver has been installed as described in Installing the ODBC Driver in the Installation Guide.

1. Open the ODBC Administrator. For example, click Start > Control Panel > Data Sources (ODBC) or Start > Control Panel > Administrative Tools > Data Sources (ODBC) depending on which version of Windows you are using.

   Differences between Windows versions and Start Menu customizations may require a different action to open the ODBC Administrator.

2. In the ODBC Data Source Administrator, click the System DSN tab to create a system-wide data source name.

   

3. In the Create a New Data Source dialog, click the Add... button, scroll down far enough to select Vertica, and click Finish.

   

4. Enter your data source information in the Vertica ODBC Driver Setup dialog.

   

   Data Source	any meaningful string. There is no special significance to the default name.
   Database	the name of the database running on the Server.
   Server	the hostname or the IP address of any active node within a Vertica database.
   User Name	either the database superuser (same name as database administrator account) or a user that has been created by the superuser and granted privileges
   Description	(optional) provides additional information about the Data Source.
   Port	the port number (5433) on which Vertica listens for ODBC connections.
   Password	the password for the specified user name.
   Read Only	prevents users of this data source from writing to the database.
   MyLog	logs only debug messages and is useful for debugging problems with the ODBC driver.
   CommLog	logs all communications between the application and the Server and is useful for application debugging.
   Cache Size	specifies the number of tuples for which to allocate memory at any given time. The default is 100 tuples.