Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?
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) and FreeTDS. I then got source and did configure/make/make installs of unixODBC first, then FreeTDS. This order is important so that the ./configure command can find all the right stuff. An important note is the params for the FreeTDS ./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 -~--~~~~--~~--~--~---
Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?
I should add a couple more things here that may have a bearing on my problem... a) I am running Ubuntu Linux and b) I am accessing my data via a VPN connection c) I have done most of my installs via Synaptics but will try to redo some with compiling from source. If I answer my own question, I will post back here. Thx again for any ideas :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 -~--~~~~--~~--~--~---
Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?
I am fairly new to Django and am working my way through the latest tutorial and get the error below. I have the latest dev for Django installed (I know cuz I started out with 0.96), the most recent FreeTDS, pyodbc and django-pyodbc. My isql and running all the api stuff works fine with my SQL Server database but, when I try to use the admin app I get the traceback below Calling up http://localhost:8000/admin/ in my browser, yeilds... Traceback (most recent call last): ...several lines here - I cut them for brevity... ProgrammingError: ('42000', '[42000] [FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (4004) (SQLExecDirectW)') I reinstall several packages to be sure I have the latest, but still no luck. Any help is appreciated! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---