dbProperties ( )

Obtains a list properties for the open connection

Usage:

dbProperties (object me)

Parameter:

None

Returns:

(Property List)
All property values are strings. The following property names could be in the property list:

• #version
• #DBMS_Name
• #DBMS_Version
• #OLD_DB_Version
• #Provider_Name
• #Provider_Version
• #Driver_Name
• #Driver_Version
• #Driver_ODBC_Version

Example:

xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
put xtRose.dbProperties( )

Notes:

Use this handler to examine your connection properties and to determine if your connection was opened successfully. Not all properties are available to all data providers. For example, Microsoft Excel using a Jet provider will not have the #Driver_Name property.

If the connection string to open the connection is invalid or if the driver is not installed, an empty list is returned.