Michael, I installed the tdsodbc package and now it's working in the ubuntu server. Tks a lot !!
On Feb 7, 11:33 am, Domingo Aguilera <[email protected]> wrote: > 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.
