Go Back

xfODBC Python

We have a customer that would like to write a Python 3.9 app to connect to our xfODBC driver. 

The initial try resulted in: Traceback (most recent call last): File "<stdin>", line 1, in <module> pyodbc.Error: ('HY000', "[HY000] [TOD][ODBC][GENESIS]Synergy DBMS: Cannot open 'GENESIS_COLUMNS',No privilege to this file or directory (-55) (SQLColumns)")

They were able to overcome this by adding a read only flag and converted their connections string to key-value pairs.

They are now wanting to establish an ORM (Object Relational Mapper) layer and are struggling finding a dialect that works with xfODBC.

Anyone out there have any experience with this?  Would appreciate any input.

Best,
​​​​​​​Gayle

1 Answer
0   | Posted by Gayle Lewis to xfODBC on 3/16/2023 3:09 PM
Steve Ives
Not an answer to your question, more of a suggestion. Have you considered implementing a Harmony Core service instead of xfODBC? You already have the fully configured repository in place because you can offer xfODBC, so generating a Harmony Core service should be trivial. My guess is that REST and OData will offer the consumer a far superior experience.

3/23/2023 4:53 PM   0  
Please log in to comment or answer this question.