Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-04-01 Thread Mark Shewfelt 

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"  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 
>
> Date: Tue, 31 Mar 2009 08:25:55
> To: Django users
> 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 "", line 1, in 
> 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  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
-~--~~~~--~~--~--~---

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-03-31 Thread Karl Gingerich 
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 

Date: Tue, 31 Mar 2009 08:25:55 
To: Django users
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 "", line 1, in 
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  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
-~--~~~~--~~--~--~---

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-03-31 Thread Mark Shewfelt 

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 "", line 1, in 
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  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
-~--~~~~--~~--~--~---

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-02-25 Thread kgingeri 

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?

2009-02-16 Thread kgingeri 

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?

2009-02-16 Thread kgingeri 

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
-~--~~~~--~~--~--~---