Thanks Karl - Actually, this morning I gave up and upgraded Ubuntu to 8.10, which uses a newer version of FreeTDS and unixODBC. It seems to work OK, though there are some funky Unicode issues using Django's TextField, but I can get around those for now.
Cheers, Mark On Mar 31, 8:41 pm, "Karl Gingerich" <kging...@gmail.com> wrote: > Mark, I'll up to my eye balls in alligators right now, I'll get back to you > soon. - Karl > > -----Original Message----- > From: Mark Shewfelt <mshewf...@gmail.com> > > Date: Tue, 31 Mar 2009 08:25:55 > To: Django users<django-users@googlegroups.com> > Subject: Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server? > > Hi Karl, > > I just came across your post and am having the same issue (Ubuntu 8.04 > Server). I managed to build the latest versions of unixODBC and > FreeTDS and install them to /usr/local/lib. When I run python and try > to import pyodbc I get the following error: > > administra...@maverick:~/pyodbc-2.1.4$ python -c "import pyodbc" > Traceback (most recent call last): > File "<string>", line 1, in <module> > ImportError: libodbc.so.1: cannot open shared object file: No such > file or directory > administra...@maverick:~/pyodbc-2.1.4$ > > So obviously pyodbc cannot find the libs I just built - but I cannot > figure out how to specify their location when building pyodbc. Did you > have this issue? Any help is welcome! > > Thanks, > > Mark > > On Feb 25, 5:19 pm, kgingeri <kging...@gmail.com> wrote: > > Ok, I figured this out myself... > > > I had to un-install all pre-installed odbc stuff - unixODBC (possibly > > iODBC as well, except it didn't seem to actually uninstall completely) > > andFreeTDS. > > > I then got source and did configure/make/make installs of unixODBC > > first, thenFreeTDS. > > This order is important so that the ./configure command can find all > > the right stuff. > > An important note is the params for theFreeTDS./configure command. > > I used the following: > > > $ ./configure --with-unixodbc=/usr/local --enable-msdblib --disable- > > libiconv --with-tdsver=8.0 > > > Anyway, it's working now without complaint! > > > :v) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---