Unsuccessful Installation

[GoogleCodeExporter]

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.

Original issue reported on code.google.com by etang...@gmail.com on 24 Aug 2011 at 7:00

[GoogleCodeExporter]

I believe this issue is identical to #169. I apologize for the duplicate.

Original comment by etang...@gmail.com on 25 Aug 2011 at 10:43

[GoogleCodeExporter]

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!

Original comment by mkleehammer on 3 Nov 2011 at 2:01

• Changed state: NoFix

[GoogleCodeExporter]

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

It works!

Original comment by greatghoul on 27 Jun 2012 at 8:56