Tks Michael, I never saw the setup directive. Did you compile driver and setup by yourself or used the anything from a debian or rpm package?
On Feb 7, 10:14 am, Michael Trier <[email protected]> wrote: > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
