OSシステムpythonインストールpyodbcモジュールの問題
リンクconn 1=pyodbc.connect("DRIVER={SQL Server};SERVER=localhost,9944;DATABASE=feptrade;UID=crawl2;PWD=crawl")
sudo pip install pyodbcの利用
呼び出しエラー
Traceback (most recent call last):
File "", line 1, in
ImportError: dlopen(/Library/Python/2.7/site-packages/pyodbc.so, 2): Library not loaded:/usr/local/lib/libodbc.2.dylib
Referenced from:/Library/Python/2.7/site-packages/pyodbc.so
Reason: image not found
解決方法:
you should install unixodbc on your system.
インストールコマンド:brew install unixodbc
sudo pip install pyodbcの利用
呼び出しエラー
Traceback (most recent call last):
File "", line 1, in
ImportError: dlopen(/Library/Python/2.7/site-packages/pyodbc.so, 2): Library not loaded:/usr/local/lib/libodbc.2.dylib
Referenced from:/Library/Python/2.7/site-packages/pyodbc.so
Reason: image not found
解決方法:
you should install unixodbc on your system.
#brew install unixodbc
==> Downloading https://homebrew.bintray.com/bottles/unixodbc-2.3.2_1.el_capitan.bottle.1.tar.gz
######################################################################## 100.0%
==> Pouring unixodbc-2.3.2_1.el_capitan.bottle.1.tar.gz
� /usr/local/Cellar/unixodbc/2.3.2_1: 31 files, 1020K
#ipython
Python 2.7.11 (default, Dec 5 2015, 14:44:53)
Type "copyright", "credits" or "license" for more information.
IPython 4.0.1 -- An enhanced Interactive Python.
? -> Introduction and overview of IPython's features.
%quickref -> Quick reference.
help -> Python's own help system.
object? -> Details about 'object', use 'object??' for extra details.
In [1]: import pyodbc
インストールコマンド:brew install unixodbc