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. BA --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
