Testing an ODBC DSN Using iodbctest
The standard iODBC Driver Manager on OS X includes a utility named iodbctest that lets you test a DSN to verify that it is correctly configured. You pass this command a connection string in the same format that you would use to open an ODBC database connection. After configuring your DSN connection, you can run a query to verify that the connection works.
For example:
# iodbctest "DSN=VerticaDSN;UID=dbadmin;PWD=password" iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0607.1008 Driver: 07.01.0200 (verticaodbcw.so) SQL> SELECT table_name FROM tables; table_name -------------------------------------------------------------------------------------------------------------------------------- customer_dimension product_dimension promotion_dimension date_dimension vendor_dimension employee_dimension shipping_dimension warehouse_dimension inventory_fact store_dimension store_sales_fact store_orders_fact online_page_dimension call_center_dimension online_sales_fact numbers result set 1 returned 16 rows.