This is the default provider for ADO, and all provider-dependent ADO properties and methods are supported.To connect to this provider, set the Provider= argument of the Connection String property to: Note If you are connecting to a data source provider that supports Windows authentication, you should specify Trusted_Connection=yes or Integrated Security = SSPI instead of user ID and password information in the connection string.However, most DBMS systems in use today can be accessed through ODBC.
How you use the Command object largely depends on the data source, and what type of query or command statement it will accept. If you want to call a stored procedure that defines no parameters, your string would look like the following: If the stored procedure will return a value, the return value is treated as another parameter.
ODBC provides a specific syntax for calling stored procedures. If you have no query parameters but you do have a return value, your string would resemble the following: The following tables list the standard ADO methods and properties available on a Recordset object opened with this provider.
You can connect with or without a predefined data source name (DSN) or File DSN.
If you use a DSN or File DSN, it must be defined through the ODBC Data Source Administrator in the Windows Control Panel.
Because you can omit the Provider parameter, you can therefore compose an ADO connection string that is identical to an ODBC connection string for the same data source.
Use the same parameter names (DRIVER=, DATABASE=, DSN=, and so on), values, and syntax as you would when composing an ODBC connection string.For the Command Text property of a Command object, the Each ? For more detailed information about Recordset behavior for your provider configuration, run the Supports method and enumerate the Properties collection of the Recordset to determine whether provider-specific dynamic properties are present.Availability of standard ADO Recordset properties: *Not supported for Microsoft Access databases.As an alternative to setting a DSN, you can specify the ODBC driver (DRIVER=), such as "SQL Server;" the server name (SERVER=); and the database name (DATABASE=).You can also specify a user account name (UID=), and the password for the user account (PWD=) in the ODBC-specific parameters or in the standard ADO-defined parameter when you use a DSN.The Microsoft OLE DB Provider for ODBC inserts several dynamic properties into the Properties collection of the unopened Connection, Recordset, and Command objects.