ADO Version/Property checking script

Last updated: 11/15/98, Initial Release

There are many versions of ADO around, and each of these has "slight" differences
in what features are supported - just recall version 1.5 (with version a through ?).
So how do you know which version of ADO is running on your (or your ISP's) web server? Luckily, the
ADO objects expose the Properties collection which allows you to browse for properties ranging from
ADO version, ODBC driver version, DBMS version and name, and more.

The script we have provided asks for the DSN, a username and password as
well as a tablename so it can go along and see which properties are supported by recordsets on this
connection (ie bookmarkable is not supported with Access databases). You can see a SQL Server output
here, taken from our guestbook service.

The main script code is presented below: first a connection object is created, a connection established
and then information about the DBMS, the drivers and versions is gathered (ADO version information). The next step is to print
all properties for the current connection as well as properties for the selected table.

The most vital information can be drawn from the first part: ADO version information, which helps
you to identify driver versions. Also important are the features of recordsets, which differ from DBMS
to DBMS.