The mssql URI is going to take the same conceptual form as any other sqlalchemry dburi. The format is documented and available in the SA docs. We can't give you the exact URI, because it's going to contain things that are specific to your application, like database name, password, etc.
ODBC under Linux I can't help you with (yet). Your best bet for MSSQL + *nix is going to be using pymssql for now. Pymssql (and any other unix-to-MSSQL connection scheme), is going to require FreeTDS to establish the basic network connection. Installing FreeTDS on Linux is going to be different for various distributions, but in general is available via normal package repositories. From your sig, I'll assume you're looking for a Debian dpkg package. I know there's one for Ubuntu, which should install on Debian, and there may be a straight-up Debian package in their repositories as well. Make sure you get a fairly recent version, as older versions assumed a Sybase set of connection parameters instead of MSSQL. The FreeTDS docs outline the issue with the various protocol versions. If you have the protocol version set wrong, then MSSQL dates won't transfer correctly. Much of this information is on the SQLAlchemy wiki under database notes, check there as well. HTH, Rick --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
