Attempting to list drivers using odbc2parquet 0.6.2.7 on Oracle Linux 7.8 after compiling it on the same os fails with State: S1009, Native error: 0, Message: [unixODBC][Driver Manager]Invalid attribute value

[pacman82]

Attempting to list drivers using odbc2parquet 0.6.2.7 on Oracle Linux 7.8 after compiling it on the same os fails with State: S1009, Native error: 0, Message: [unixODBC][Driver Manager]Invalid attribute value

[pacman82]

What version of Unix odbc is installed?

[pacman82]

Hello @chrisfw ,

so now I've found a bit of time to write a more elaborate answer. Thanks for opening the issue. To help our understanding let's translate the error message, which you kindly provided.

ODBC emitted an error calling 'SQLSetEnvAttr':
State: S1009, Native error: 0, Message: [unixODBC][Driver Manager]Invalid attribute value

This error was emitted calling SQLSetEnvAttr which is only called in one place if executing odbc2parquet: Then setting the ODBC API version number. At the beginning of its lifecycle any ODBC application declares which version of the ODBC standard it wants to use to communicate to the driver manager (unixODBC).

In that context the Invalid attribute value is the version number. odbc2parquet currently utilizes the version 3.80 of the ODBC standard. Note: This is the version of the ODBC standard not the version of the driver manager odbc2parquet expects.

The error indicates, that your version of the driver manager does not even know that this version exists. Which leaves me to belive that it might be an outdated version of unixODBC.

Checking the changelog of unixODBC the ODBC 3.80 is first mentioned for the version unixODBC 2.3.0 which has been released 2010. See: http://www.unixodbc.org/

In terms of this tool I find the error message you received less than ideal. Best to emit a better error in the upstream odbc-api if setting the desired ODBC version fails. This however won't solve your problem. It would still fail, just with a nicer error. Yet an update of unixODBC packet might.

Please let me know if any of this has been helpful, and if the diagnose turned out to be correct or not.

Cheers, Markus

[pacman82]

Just released odbc2parquet 0.6.28 which is going to emit a better error message in your situation. Still curious on what version of unixODBC you are running though.

Cheers, Markus

[chrisfw]

Hi Markus, We are on unixODBC 2.3.1. $ isql --version unixODBC 2.3.1 Thanks, Chris

…

On Fri, Mar 25, 2022 at 1:19 PM Markus Klein ***@***.***> wrote: Just released odbc2parquet 0.6.28 which is going to emit a better error message in your situation. Still curious on what version of unixODBC you are running though. Cheers, Markus — Reply to this email directly, view it on GitHub <#168 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABOZ7PKCP3H6UKKYGGDJ2GDVBXYQVANCNFSM5RSSPKAA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pacman82]

Hi Chris,

would you mind upgrading to a newer version, and tell me how it goes. FYI: In case your package manager does not provide the newest version, building unixODBC from source is pretty straight forward:

1. copy the unixODBC-2.3.9.tar.gz file somewhere you can create files and directories
2. gunzip unixODBC*.tar.gz
3. tar xvf unixODBC*.tar
4. `./configure`
5. `make`
6. `make install`

I am not sure, at what version unixODBC officially supports ODBC 3.80, but the latest version does for sure. So updating it is something I find worth trying.

Cheers, Markus

[chrisfw]

Hi Markus, I’ll need to find a server to test on as I was working on a customer vm, but I’ll do as you suggest and let you know what I find out. Thanks! Regards, Chris

…

On Mar 26, 2022, at 11:53 AM, Markus Klein ***@***.***> wrote:  Hi Chris, would you mind upgrading to a newer version, and tell me how it goes. FYI: In case your package manager does not provide the newest version, building unixODBC from source is pretty straight forward: 1. copy the unixODBC-2.3.9.tar.gz file somewhere you can create files and directories 2. gunzip unixODBC*.tar.gz 3. tar xvf unixODBC*.tar 4. `./configure` 5. `make` 6. `make install` I am not sure, at what version unixODBC officially supports ODBC 3.80, but the latest version does for sure. So updating it is something I find worth trying. Cheers, Markus — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.

[chrisfw]

Hi Markus, This may take me some time to get to, but I will let you know when I have had an opportunity to test it out. Thanks, Chris On Sat, Mar 26, 2022 at 1:23 PM Chris Whelan ***@***.***> wrote:

…

Hi Markus, I’ll need to find a server to test on as I was working on a customer vm, but I’ll do as you suggest and let you know what I find out. Thanks! Regards, Chris On Mar 26, 2022, at 11:53 AM, Markus Klein ***@***.***> wrote:  Hi Chris, would you mind upgrading to a newer version, and tell me how it goes. FYI: In case your package manager does not provide the newest version, building unixODBC from source is pretty straight forward: 1. copy the unixODBC-2.3.9.tar.gz file somewhere you can create files and directories 2. gunzip unixODBC*.tar.gz 3. tar xvf unixODBC*.tar 4. `./configure` 5. `make` 6. `make install` I am not sure, at what version unixODBC officially supports ODBC 3.80, but the latest version does for sure. So updating it is something I find worth trying. Cheers, Markus — Reply to this email directly, view it on GitHub <#168 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABOZ7POQI5T7YB2I4D2PUDDVB4XGVANCNFSM5RSSPKAA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pacman82]

Hi Chris,

looking forward to it. This might become relevant for me, too.

Cheers, Markus

[chrisfw]

Hi Markus, I confirmed that it works properly on Ubuntu with unixODBC 2.3.6 against Oracle 19c with the 19c ODBC driver, so you can close out the issue. Thank you! Regards. Chris

…

On Tue, Mar 29, 2022 at 2:00 AM Markus Klein ***@***.***> wrote: Hi Chris, looking forward to it. This might become relevant for me, too. Cheers, Markus — Reply to this email directly, view it on GitHub <#168 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABOZ7POGKQPAAOH2SQXSMRDVCKL6XANCNFSM5RSSPKAA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pacman82]

Hi Chris,

Thanks for the feedback. Closing the issue.

Cheers, Markus

[chrisfw]

No problem Markus! Regards, Chris

…

On Mar 31, 2022, at 7:02 AM, Markus Klein ***@***.***> wrote:  Hi Chris, Thanks for the feedback. Closing the issue. Cheers, Markus — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.

[chrisfw]

Thank you Markus for your quick response and all of the info you provided. I will investigate on my end and let you know what I find out. Regards, Chris

…

On Mar 25, 2022, at 1:19 PM, Markus Klein ***@***.***> wrote:  Just released odbc2parquet 0.6.28 which is going to emit a better error message in your situation. Still curious on what version of unixODBC you are running though. Cheers, Markus — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.