Hi Alchemists,
I am starting a project in Pylons that will need to access a MSSQL
database. I plan to develop on Windows and deploy on Linux. It sounds
like pyodbc is the best option and that it is reasonably well
supported. I've done a lot of Google searching but I haven't been able
to find answers to the following issues.
1. What is the correct format for the connection url?
My guess was the following:
engine = create_engine('mssql://username:[EMAIL PROTECTED]:port/database',
echo=True, module=pyodbc)
but engine.connect() fails.
Should the hostname be the IP of the server or SQL Server's
host\instance combination?
Isn't the port normally 1433?
2. I saw an archived email that said there was better support for
MSSQL in 0.3 than in 0.4. Is that still the case?
3. I'll be piggy backing on an existing ERP system and I'm trying to
decide what would be the best way to store new tables
- in the DB used by the ERP system
- in a new DB on the same MSSQL server
- in a SQLite DB
How easy does SA make it to use data from multiple DBs?
Thank you very much for your help and work on SQLAlchemy,
Scott
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
