Microsoft OLE DB Provider for Internet Publishing
The Microsoft OLE DB Provider for Internet Publishing allows ADO to access resources served by Microsoft FrontPage or Microsoft Internet Information Server. Resources include web source files such as HTML files, or Windows 2000 web folders.
A typical connection string for this provider is:
"Provider=MSDAIPP.DSO;Data Source=ResourceURL;User ID=MyUserID;Password=MyPassword;"
The string consists of these keywords:
Specifies the OLE DB Provider for Internet Publishing.
Data Source -or- URL
Specifies the URL of a file or directory published in a Web Folder.
Specifies the user name.
Specifies the user password.
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.
If you set the ResourceURL value from the "URL=" in the connection string to an invalid value, by default the Internet Publishing Provider raises a dialog box to prompt for a valid value. This is undesirable behavior for a component in the middle tier of an application, because it suspends program execution until the dialog box is cleared and the client appears to freeze because it has not received a response from the component.
If MSDAIPP.DSO is explicitly specified as the value of the provider, either with the Provider connection string keyword or the Provider property, you cannot use "URL=" in the connection string. If you do, an error will occur. Instead, simply specify the URL as shown in the topic Using ADO with the OLE DB Provider for Internet Publishing.