My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 55: sql.h: No such file or drectory
19 people starred this issue and may be notified of changes. Back to list
Status:  NoFix
Owner:  ----
Closed:  Aug 2009


 
Reported by stevenl...@gmail.com, Jun 7, 2009
What steps will reproduce the problem?
1. wget http://pyodbc.googlecode.com/files/pyodbc-2.1.5.zip
2. unzip pyodbc-2.1.5.zip
3. cd pyodbc-2.1.5/
4. sudo python setup.py install

What is the expected output? What do you see instead?

running install
running build
running build_ext
building 'pyodbc' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-
prototypes -fPIC -DPYODBC_MAJOR=2 -DPYODBC_MINOR=1 -DPYODBC_MICRO=6 -
DPYODBC_BUILD=0 -I/usr/local/python2.6/include/python2.6 -c /tmp/pyodbc-
2.1.6/src/buffer.cpp -o build/temp.linux-x86_64-2.6/tmp/pyodbc-
2.1.6/src/buffer.o -Wno-write-strings
cc1plus: warning: command line option "-Wstrict-prototypes" is valid for 
Ada/C/ObjC but not for C++
In file included from /tmp/pyodbc-2.1.6/src/buffer.cpp:12:
/tmp/pyodbc-2.1.6/src/pyodbc.h:76:17: error: sql.h: No such file or 
directory
/tmp/pyodbc-2.1.6/src/pyodbc.h:77:20: error: sqlext.h: No such file or 
directory
/tmp/pyodbc-2.1.6/src/pyodbc.h:93: error: 'IsSet' declared as an 'inline' 
variable
/tmp/pyodbc-2.1.6/src/pyodbc.h:93: error: 'DWORD' was not declared in this 
scope
/tmp/pyodbc-2.1.6/src/pyodbc.h:93: error: 'DWORD' was not declared in this 
scope
/tmp/pyodbc-2.1.6/src/pyodbc.h:93: error: initializer expression list 
treated as compound expression
/tmp/pyodbc-2.1.6/src/pyodbc.h:94: error: expected ',' or ';' before '{' 
token
/tmp/pyodbc-2.1.6/src/buffer.h:44: error: 'SQLLEN' has not been declared
/tmp/pyodbc-2.1.6/src/pyodbcmodule.h:43: error: 'HENV' does not name a type
/usr/local/python2.6/include/python2.6/datetime.h:186: warning: 
'PyDateTimeAPI' defined but not used
error: command 'gcc' failed with exit status 1


What version of the product are you using? On what operating system?

Ubuntu Hardy, python 2.6.2

Please provide any additional information below.


Jun 7, 2009
#1 stevenl...@gmail.com
Nevermind, just realized I didn't have unixodbc installed.  Sorry about wasting your 
time.
Aug 7, 2009
Project Member #2 mkleehammer
(No comment was entered for this change.)
Status: Invalid
Nov 21, 2010
Project Member #3 mkleehammer
(No comment was entered for this change.)
Status: NoFix
Jan 31, 2011
#4 valhall...@gmail.com
Even while it is caused by not having unixodbc installed - the install should fail with that as a message. It is not clear at all that sql.h and sqlext.h belong to unixodbc.
Jul 4, 2012
#5 yaa...@gmail.com
You need unixodbc-dev
Sep 8, 2013
#6 Ahmad8...@gmail.com
on centOS

yum install unixODBC*

Powered by Google Project Hosting