Results 1 to 3 of 3

Thread: ODBC connection to Lianja from Python

  1. #1

    ODBC connection to Lianja from Python


    I've tried to figure this one out on my own, but no luck.
    I have a migration process to Lianja occurring in stages.
    But the data will be live I Lianja from Day 1.

    I need the rest of the applications to be able to read the data from python until they are all moved over.

    I am testing out how best to access the Lianja databases from outside Python code.

    To test, I have configured the Lianja ODBC connection "Lianja_Soutwind" and successfully tested the connection.

    However, I am unable to connect using pyodbc.

    Is there a different, recommended way I should be connecting to Lianja?


    Name:  ODBCLianja.jpg
Views: 772
Size:  73.2 KB

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    UK, USA, Thailand
    Blog Entries
    You would appear to be using your own Python installation which is probably x64 rather than the python we provide that is also embedded in Lianja.

    As per the error message you have a x64 and x86 mismatch of drivers.
    Principal developer of Lianja, Recital and other products

    Follow me on:


  3. #3
    Hi Barry,

    Thanks for that. I am still coming up to speed on python.

    We have an internal team at the Fund that uses Python a lot. I am trying to show them the light of Lianja

    So for now, I do need to test both the code in Lianja and from the current external install.

    It's all working now. Thanks for your help.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Journey into the Cloud
Join us