+1. It's been sitting on my todolist (and I submitted a patch to make it work without requiring an install) but until DSN/SSPI are kinda "transparent" I didn't want to introduce it in DAL's core. There were also some problems on properly closing connections, but I didn't dig deeper in it.
On Thursday, March 20, 2014 12:57:06 AM UTC+1, Derek wrote: > > Back in November, niphlod (?sp) said that he'd look into adding pytds > support to DAL. I didn't have a chance to look a lot at pytds until > recently, I don't see that it's supported yet. I believe the only thing > missing from pytds to be able to add support is the DSN connection syntax. > If anyone is interested, I could do a pull request and see if we can get > that incorporated into pytds. I just reported a few issues with it and > those were fixed (related to transactions on sql 2000), so I think it's > mature enough to add. If anyone wants to add it to the DAL, I can offer my > support as far as testing and workarounds for some issues it may have (its > DBAPI 2.0 support is a little wonky). > > Why PyTDS? You get MS SQL Server support with 0 binaries required on the > host, it's 100% pure python (well, you'd benefit from bitarray, but it's > not required). It doesn't use ODBC or anything, just straight TCP. That > also means that you could run this with greenlets without reverting to > seralized operations. The current pyodbc and pypyodbc still use the > platform's odbc drivers which are written in C. > -- 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/d/optout.
