Data source name not found and no default driver specified (using Amazon Redshift (x64))

Question

private OdbcConnection _internalConnection;
        public OdbcConnection InternalConnection
        {
            get
            {
                if (_internalConnection == null)
                {
                    Open();
                }
                return _internalConnection;
            }
        }

        public void Open()
        {
            _internalConnection = new OdbcConnection(CreateConnectionString());

            try
            {
                if (_internalConnection.State == System.Data.ConnectionState.Closed)
                    _internalConnection.Open();
            }
            catch
            {
                throw;
            }
        }

        private string CreateConnectionString()
        {

            int endpointPort = 5439;

            string driver = "{Amazon Redshift (x64)}";
            string connectionString = "Driver={0};Server={1};Database={2};UID={3};PWD={4};Port={5};SSL=true;Sslmode=Require";

            connectionString = string.Format(connectionString,
                driver,
                Parameters[ConnectionParameterType.DataSource],
                Parameters[ConnectionParameterType.DatabaseName],
                Parameters[ConnectionParameterType.UserName],
                Parameters[ConnectionParameterType.Password],
                endpointPort);

            return connectionString;
        }

see error in image

Answer 1

install 32 bit driver

https://s3.amazonaws.com/redshift-downloads/drivers/AmazonRedshiftODBC32-1.3.1.1000.msi

and replace string driver with

string driver = "{Amazon Redshift (x86)}";