Issue 205: Unsuccessful Installation
Status:  NoFix
Owner: ----
Closed:  Nov 2011
Reported by etang...@gmail.com, Aug 24, 2011
What steps will reproduce the problem?
1. sudo pip install https://github.com/mkleehammer/pyodbc/zipball/2.1.9

What is the expected output? What do you see instead?
successful installation
-----------------------------------------------------

creating build/temp.linux-i686-2.6/utils/pyodbcconf

gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -DPYODBC_VERSION=2.1.0-unsupported -I/usr/include/python2.6 -c utils/pyodbcconf/pyodbcconf.cpp -o build/temp.linux-i686-2.6/utils/pyodbcconf/pyodbcconf.o -Wno-write-strings

cc1plus: warning: command line option "-Wstrict-prototypes" is valid for Ada/C/ObjC but not for C++

utils/pyodbcconf/pyodbcconf.cpp:25:17: error: sql.h: No such file or directory

utils/pyodbcconf/pyodbcconf.cpp:26:20: error: sqlext.h: No such file or directory

utils/pyodbcconf/pyodbcconf.cpp: In function ‘PyObject* mod_configure(PyObject*)’:

utils/pyodbcconf/pyodbcconf.cpp:58: error: ‘SQLWCHAR’ was not declared in this scope

error: command 'gcc' failed with exit status 1

----------------------------------------
Command python setup.py egg_info failed with error code 1


What version of the product are you using? On what operating system?
pyodbc-2.1.9 on ubuntu-10.04.3

Please provide any additional information below.
I looked at another ticket which suggested the above course of action.
Trying the same with 2.1.8 produces a different error log.
I have unixODBC and FreeTDS installed.

Aug 25, 2011
#1 etang...@gmail.com
I believe this issue is identical to #169. I apologize for the duplicate.
Nov 2, 2011
Project Member #2 mkleehammer
sql.h: No such file or directory

It appears you do not have the unixODBC development package unixodbc-devel.  This package contains the header and library files needed to build against unixODBC:

sudo apt-get install unixodbc-dev unixodbc-bin unixodbc

Good luck!
Status: NoFix
Jun 27, 2012
#3 greatghoul
> sudo apt-get install unixodbc-dev unixodbc-bin unixodbc

It works!