General discussion on using the Kognitio Analytical Platform.
Multiple Poster
User avatar
Posts: 5
Joined: Tue May 03, 2016 10:10 am

ODBC Connection Python Mac

by awilliams » Tue Jan 10, 2017 9:52 am

Trying to set up a connection on Python 2.7.12 running on Mac 10.12.2 using pyodbc module. Is there a how to kind? I have installed the latest ODBC drivers from and using the Mac console works fine. However I need a connection through Python yet I seem to be struggling to set up either through creating a DSN and/or passing a full connection string.

Any help would be appreciated.
Reply with quote Top
Posts: 39
Joined: Mon Jan 06, 2014 10:36 am

Re: ODBC Connection Python Mac

by skkirkham » Wed Jan 11, 2017 9:41 am


If you are you using an ODBC DSN manager such as unixODBC or iODBC this thread explains how to set up an ODBC connection using pyodbc on Linux that might give you some pointers.

Reply with quote Top
User avatar
Posts: 21
Joined: Mon Oct 07, 2013 12:15 pm

Re: ODBC Connection Python Mac

by ChakLeung » Wed Jan 11, 2017 4:01 pm

I found some guides to installing unixODBC and pyodbc on Mac OS via Homebrew and pip.

You'll need to edit the odbc.ini files to point them at the right server but if you can also use iODBC which comes with an odbc manager to add them in a Windows-like GUI. The driver you'll need to use for your DSNs is the one you've linked.

Without unixodbc -
With unixodbc ... or-pyodbc/

Homebrew -
iODBC - ... meVisitors

Hope this starts you off in the right direction, good luck.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest