Database Access from AutoLISP using ActiveX Data Objects (ADO)

A library (similar to DBL) to make it easier to connect to a database from AutoCAD 2000 or higher. Contains functions to open a database, execute an arbitrary SQL statement (without replaceable parameters), and close a database. Includes extensive documentation, some examples and a sample database, and sophisticated error handling and reporting.

Includes several useful support routines to collect errors into a list, print errors, and convert variant types that (vlax-variant-value ...) does not understand (such as date, time, currency, and decimal).

Version 2.50 is now compatible with Microsoft patch KB927779. Alas, this requires changing the return value of ADOLISP_DoSQL when the SQL statment is a non-cursor statement (INSERT ..., UPDATE ..., or DELETE...). Formerly, when running in AutoCAD 2000i or above, ADOLISP_DoSQL returned the integer number of rows affected when the excution succeeded. Now it returns T (that is, non-nil) and there is no information on the number of rows affected. This may require changes in your code!

Version 2.51 uses a differnet workaround for KB927779 which fixes tthe bug of executing stored procedures twice. Version 2.52 is compatibe wwith AUtoCAD 2008, including running under Vista (and is probably compatible with any earlier versions you can get runing under Vista)

Requires AutoCAD 2000 or higher. Tested in all versions from 2000 through 2008 (and should work in higher versions when they show up).

Freeware. No charge.

Download ADOLisp252.zip

© Copyright 2007 The Fleming Group