aws / aws/amazon-redshift-odbc-driver

Failing to successfully 'link table' with this driver version with MS Access 365.

Open
#1 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
25
Forks
17
PR merge metrics
No merged PRs in 30d

Description

## Driver version
2.00.00.01

## Redshift version
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.40182
## Client Operating System
Winbdows 2011 64 bit

## Table schema
All tables & vies

## Problem description
Failing to successfully 'link table' with this driver version with MS Access 365.

Notable errors from the odbc driver connection log:
Jul 21 07:42:11.386 TRACE 26864 Simba::ODBC::Connection::SQLGetConnectAttr: +++++ enter +++++
Jul 21 07:42:11.386 INFO 26864 Simba::ODBC::Connection::SQLGetConnectAttr: Attribute: Unknown Attribute (30002)
Jul 21 07:42:11.399 ERROR 26864 Simba::ODBC::Connection::SQLGetConnectAttr: [Amazon][ODBC] (10210) Attribute identifier invalid or not supported: 30002

Our prior installed version driver (1.04.56.1000) does not return this error. Thank you :)

->

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the failure when linking a table from MS Access 365 with driver 2.00.00.01, using the supplied ODBC connection log and the SQLGetConnectAttr attribute 30002 error. Compare the behavior with driver 1.04.56.1000 and the reported Redshift/PostgreSQL environment. Done means Access links the tables successfully without this connection error.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.