I run ubuntu 10.04, I had freeTDS 0.82 and unixODBC 2.2.11 working
fine (installed with apt-get). I installed pyodbc and that worked as
well.

Recently, I needed a higher version of freeTDS, I uninstalled all of
those things and installed in order (from source, because the
repositories were out of date):
unixODBC 2.3
freeTDS 0.91

up through this point everything worked fine. Now I am trying to build
and install pyodbc from source:
----
 Traceback (most recent call last):
  File "setup.py", line 326, in <module>
    main()
  File "setup.py", line 61, in main
    settings = get_compiler_settings(version_str)
  File "setup.py", line 147, in get_compiler_settings
    get_config(settings, version_str)
  File "setup.py", line 196, in get_config
    import pyodbcconf
ImportError: libodbc.so.1: cannot open shared object file: No such
file or directory
----

the only similar post I can find was this guy:

http://groups.google.com/group/pyodbc/browse_thread/thread/c8f69db656...

and he seemed to have solved it himself by changing environment
variables. However, I currently have no idea what the right path is to
set. What should I do to install pyodbc correctly?

-Yan