Specifies the options for adding an ADO (Microsoft ActiveX Data Objects) database.
The ADO interface is a Microsoft Windows proprietary container for connecting to databases.
To connect to an Access 2000 file, use the format:
PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\Access\nwind2000.mdb
To connect with a name to a catalog on a Microsoft SQL server that has a name turner, enter:
PROVIDER=sqloledb;DATA SOURCE=turner;INITIAL CATALOG=First
To access an ODBC driver as a provider:
DSN=SQLSERVER
Click to open a database selection dialog.
A user name can have a maximum of 18 characters.
This page is: /text/sdatabase/dabawiz02ado.xhp
Title is: ADO Connection
