I'm planning to include another tds pure python driver that **seems** to
avoid all this freetds ugliness, but the adapter library is a tad bit
experimental. keeps fingers crossed a little bit more.
On Friday, February 14, 2014 4:38:32 PM UTC+1, Falk wrote:
>
> Hi,
>
> After some frenzied trying with codecs and views, I finally got it to work.
> It's a ugly hack, but works "for the moment"
>
> In dal.py I added: (TDS_VERSION=8.0)
> cnxn = 'SERVER=%s;PORT=%s;DATABASE=%s;UID=%s;PWD=%s*;TDS_VERSION=8.0*;%s'
> \
> % (host, port, db, user, password, urlargs)
>
> I could not make it work with url name-values in the connection string
> like ?DRIVER={FreeTDS};TDS_VERSION=8.0..
>
> I guess that there is some config error by me in the FreeTDS config, or
> that there are some interesting stuff going on in the remote mssql database
> settings.
> Beq, I need to do the connection with db_codec='latin1' to not get the
> 'exceptions.UnicodeDecodeError'> 'utf8' codec can't decode byte 0xe4...
>
> So, this is sorta solved with duct tape and good intentions :)
>
> --
> Regards Falk
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
