Results 1 to 3 of 3

Thread: ODBC connection to Lianja from Python

  1. #1
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,237

    ODBC connection to Lianja from Python

    Hi,

    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?

    Thanks.

    Herb
    Name:  ODBCLianja.jpg
Views: 405
Size:  73.2 KB

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,083
    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:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,237
    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.

    Herb

Bookmarks

Bookmarks

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