![]() Amazon Redshift ODBC Driver (32-bit) Choose the System DSN tab to configure the driver for. For more information, see the section About ODBC data sources. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add. The ODBC Data Source Administrator dialog box appears. In the Administrative Tools dialog box, double-click Data Sources (ODBC). Sudo ln -s /Library/ODBC/odbcinst.ini /opt/local/etc/odbcinst. For package installation:Cassandra is supported on Mac OS X. In the Control Panel, double-click Administrative Tools. The cleanest fix seems to be simply symlinking from the Mac Ports location to the system location, so that a common set of configuration files will work for any tool, regardless of where it's looking for this information: sudo ln -s /Library/ODBC/odbc.ini /opt/local/etc/odbc.ini This explains why iodbctest works, but the pyodbc chokes. It appears as if the system stores ODBC configuration data in /Library/ODBC, but the Mac Ports stores configuration in /opt/local/etc. Not really sure why, but just wanted to let you know what I had to do to get it to work. Updated (since I can't answer my own question yet) There are lots of ODBC drivers and SQL software packages that promise to do it, but in the end I had to run a virtual machine of Windows and Office 2010 to get this to work. ![]() Why can't pyodbc find the ODBC drivers and/or my DSN configurations? Not found, and no default driver specified (0) (SQLDriverConnectW)') Pyodbc.Error: ('IM002', ' Data source name ![]() I then attempt to connect to the database using pyodbc: import pyodbcĬnxn = nnect('DSN=my-dsn-name UID=joe PWD=secret')Īnd I get the following lovely error: Traceback (most recent call last): After installing, I created a DSN for my remote database, and verified that the configuration works using the iodbctest utility. Made for 64-bit Intel and Apple Silicon ODBC drivers. ![]() Freely re-distributable - include it with your application package. Since OSX no longer supplies the ODBC Administrator application, I've installed the OpenLink ODBC manager. We periodically test the latest ODBC drivers against various database backends to ascertain the driver which works best and is the most stable with our ODBC DAM. Replaces ODBC Administrator omitted from Snow Leopard. I've installed the mac ports package for py27-odbc on Snow Leopard. ![]()
0 Comments
Leave a Reply. |