Creating a Data Source Name

Typically, after installing the Simba Square ODBC Driver, you need to create a Data Source Name (DSN). A DSN is a data structure that stores connection information so that it can be used by the connector to connect to Square.

The following instructions describe how to create a DSN. For information about specifying settings in a connection string, see Using a Connection String.

To create a Data Source Name:

  1. From the Start menu, go to ODBC Data Sources.

    Note: Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Square.

  2. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

      Note: It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  3. Click Add.
  4. In the Data Source Name field, type a name for your DSN.
  5. Optionally, in the Description field, type relevant details about the DSN.
  1. In the Host field, type the endpoint of the Square server.
  2. Optionally, in the Port field, type the number of the TCP port that the Square server uses to listen for client connections.
  3. In the Authentication section, configure the authentication options. For more information, see Configuring Authentication.
  4. To enable double-buffering and prefetch data when executing queries, select the Enable Double-Buffering check box.
  5. To enable TLS/SSL encryption, select the Use HTTPS check box.
  6. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  7. To test the connection, click Test. Review the results as needed, and then click OK.
    Note: If the connection fails, then confirm that the settings in the Simba Square ODBC Driver DSN Setup dialog box are correct. Contact your Square server administrator as needed.
  8. To save your settings and close the Simba Square ODBC Driver DSN Setup dialog box, click OK.
  9. To close the ODBC Data Source Administrator, click OK.