Hi,
Should the hostname be the IP of the server or SQL Server's
host\instance combination?
Both work ok for me.
Isn't the port normally 1433?
Yup
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?
Support in 0.4 is
see some notes at
http://www.sqlalchemy.org/trac/wiki/DatabaseNotes
also check dbcook.usage.sa_engine_defs.py at
(svn co)
https://dbcook.svn.sourceforge.net/svnroot/dbcook/trunk/dbcook/usage/
for some create/drop stuff, both pyodbs/pymssql.
3. I'll be piggy backing on an existing ERP system
Hi Scott,
...to develop on Windows and deploy on Linux. It sounds
like pyodbc is the best option
pyodbc works well in Windows, but I've heard on Linux, not so much. pymssql
is your best bet for Linux. Note that pymssql does not work with unicode,
limits SQL identifiers to 30 characters, and
