aws / aws/amazon-redshift-odbc-driver
Failing to successfully 'link table' with this driver version with MS Access 365.
- 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
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