Hi,
On Feb 7, 2010, at 9:59 AM, Domingo Aguilera wrote: > I tried 0.8 with 0.6b1 but didn't work. Both 0.8 and 1.0.2 work with > sqla 0.5.8 without problems. > > I began trying using pyodbc in ubuntu yesterday but can't even make it > run unixodbc with freetds to reach a sqlserver . If someone has > configuration tips ot make this work .... please let me know. > This is on a pylons application, not that it matters. I'm using the following configuration. You can just translate it into the appropriate engine connection statement: sqlalchemy.url = mssql://user:passw...@server/database?driver=FreeTDS&port=50008 sqlalchemy.convert_unicode = True sqlalchemy.encoding = 'latin1' My odbcinst.ini looks like: #: cat odbcinst.ini [FreeTDS] Description = TDS driver Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so CPTimeout = CPReuse = I have nothing in my freetds.conf. It was a pain to get it working right. What I recommend is you test a piece at a time. Make sure you can connect with just straight FreeTDS. Then make sure you can connect with straight FreeTDS going through unixodbc, and so forth. Incidentally the configuration on my Mac is completely different. Michael -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
