On Thursday 28 December 2006 17:31, Ed Leafe wrote: > 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-dev
Not only cool - but very cool! Thank you for taking the time. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
