Hi,
I had sent a request for help the other day (Subject " freetds and iodbc
to access Microsoft SQL Server 2005") to m...@. (I sent my thanks
directly to everyone who tried to help but did not copy misc@ to reduce
unnecessary email messages)
It looks like I should use py-sqlalchemy which requires pyodbc. So I
tried to install pyodbc. Initial attempts failed but once I copied
iodbcunix.h, sql.h, sqlext.h, sqltypes.h, and sqlucode.h from
/usr/local/include to /usr/include I got this far.
$ sudo python2.5 setup.py build install
running build
running build_ext
building 'pyodbc' extension
c++ -shared -L/usr/ports/lang/python/2.5/w-Python-2.5.4/Python-2.5.4
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/buffer.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/cnxninfo.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/connection.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/cursor.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/errors.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/getdata.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/params.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/pyodbcmodule.o
build/temp.openbsd-4.5-i386-2.5/home/vsankar/Downloads/SQLAlchemy/pyodbc-2.1.6/src/row.o
-lodbc -o build/lib.openbsd-4.5-i386-2.5/pyodbc.so
/usr/bin/ld: cannot find -lodbc
collect2: ld returned 1 exit status
error: command 'c++' failed with exit status 1
So I have two questions:
1) How can I compile and make pyodbc run on 4.5 -stable?
2) I had to copy iodbcunix.h, sql.h, sqlext.h, sqltypes.h, and
sqlucode.h from /usr/local/include to /usr/include. How can I compile so
that this is not necessary?
Thanks again,
Vijay
--
Vijay Sankar, M.Eng., P.Eng.
ForeTell Technologies Limited
59 Flamingo Avenue, Winnipeg, MB, Canada R3J 0X6
Phone: (204) 885-9535, E-Mail: [email protected]
