KNOWLEDGE BASE

Error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Connecting to Amazon Redshift


Published: 08 Jan 2016
Last Modified Date: 28 Dec 2016

Issue

When you try to connect to Amazon Redshift the following error message appears:  
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Unable to connect to the server "<Server Name>". Check that the server is running and that you have access privileges to the requested database

Environment

  • Tableau Desktop
  • Amazon Redshift

Resolution

Install the latest Amazon Redshift drivers.For more information, see Driver Download.

Cause

Missing drivers.
Did this article resolve the issue?