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

Cheers,
Bjorn Swift

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

Reply via email to