Brad Anderson wrote: > Björn Swift wrote: > >> There is a way to use Micrcosoft SQL Server 2000 as database > >> backend insteed of sqllite? > > > > Yes, there is. What you need is a Python MSSQL binding to be able to > > connect to your MSSQL server. There are a few out there, each with it's > > pros/cons. > > > > Pymssql (http://pymssql.sourceforge.net/) is probably the fastest. It is, > > however, using an old (discontinued) version of Microsoft's DBLIB. DBLIB > > has it's limitations, such as a 30 character column limitation, a VARCHAR > > limitation of 255 characters and limited Unicode support. > > > > MSSQL-0.09 (http://www.object-craft.com.au/projects/mssql/download.html), > > also dependent on dblib with it's limitations. > > > > Adodbapi (http://adodbapi.sourceforge.net/). Uses Microsoft ADO and > > win32all (http://starship.python.net/crew/mhammond/) for COM interaction. > > It's Unicode friendly and supports varchar/nvarchar MAX without problem, > > but it's not what one would call blazingly fast. > > > > (If any of this is wrong, please correct me!) > > > > Once you have these bindings installed (and working!) you can install your > > Trac environment on a MSSQL database using the mssql://[EMAIL > > PROTECTED]:host/database syntax. > > If this is going to be done, I would strongly recommend something that uses > FreeTDS because that lib works on *nix and Windows platforms. I'm not sure if > all the ones listed by Bjorn use this (the dblib ones) or if there are any > Python bindings that use ctlib within FreeTDS. But as a lot of Trac servers > run *nix, I thought I'd throw this out there as a requirement.
Pymssql is written so that it can be compiled with the MS database library or FreeTDS. FreeTDS is of course used on all non-Windows platforms. At least by default the Windows version uses the MS library, though in my experience it was much more reliable with FreeTDS, so I don't know if there'd be a way to compile it with it on Windows too. Of course this doesn't change the fact that Trac does not support MSSQL at this time. However, it should be possible once we switch to SQLAlchemy for the database abstraction. -- Matt Good --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" 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/trac-users -~----------~----~----~----~------~----~------~--~---
