OK, I haven't tested everything, but I'm able to use a modified
SimpleFormWithBizobj to query, modify and save from Microsoft SQL
Server 2000. I have not attempted deletion or insertion, and I know
that MS SQL uses different syntax for its identity columns, so I'm
sure that some work will need to be added.
Thanks to John Fabiani, who did most of the work getting all this
working.
If anyone has a SQL Server they want to test this with, here are the
basic steps:
1) Download and install FreeTDS if you are running Linux/OS X. NOTE:
FreeTDS must be configured with --enable-msdblib to return correct
dates! See README.freetds for details.
2) Windows systems require: SQL Developer Tools, to be found on MS
SQL 2000 installation media (also need to install MS SQL Client Tools
with Developer Tools).
3) Download and install pymssql.py from their site: http://
pymssql.sourceforge.net/
4) Download the *modified* pymssql.py from: ftp://leafe.com/pymssql.py
5) Copy the modified pymssql.py into your site-packages directory,
overwriting the one that was installed in step 3.
6) Make sure that you have the latest and greatest Subversion copy of
dabo/db/dbMsSQL.py
This should be enough to get you started. When we've worked out all
the bugs, we'll have to write up detailed instructions on the Wiki
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
