![]() To identify a keyword used after the Provider keyword, use the property description of the OLE DB initialization property that you want to set. ![]() If the Provider keyword is specified but names a provider that does not exist or is invalid, as in the following example, an error is returned. The ODBC connection string in the following example can be passed in, and it will successfully connect. This provides backward compatibility with ODBC connection strings. If no Provider keyword is in the string, the OLE DB Provider for ODBC (MSDASQL) is the default value. If two versions are installed on a system and the VersionIndependentProgID value is specified, the most recent version of the provider is used. If two versions of a provider are installed on the same system, use the ProgID to specify exactly which version to use. The value can also be set to the ProgID of the provider, which may have a version attached to it. To specify your OLE DB provider, set the value of the Provider keyword to the VersionIndependentProgID value of the provider. The Provider keyword identifies the OLE DB provider to be used. The equal sign (=) connects each keyword and its value. The string consists of a series of keyword/value pairs separated by semicolons. The basic format of a connection string is based on the ODBC connection string. In these cases, it is important that the connection string syntax adhere to the formatting rules described in the following sections. In some cases, rather than using the standard data link user interface, it might be desirable to build a connection string within an application ? for example, if you want to provide a custom user interface. In ADO, connection strings are retrieved and set using the ConnectionString property to create a Connection object.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |