Export (0) Print
Expand All

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.

To connect to this provider, set the Provider argument of the ConnectionString property to:

MSDAIPP.DSO

This value can also be set or read using the Provider property.

A typical connection string for this provider is:

"Provider=MSDAIPP.DSO;Data Source=ResourceURL;User ID=MyUserID;Password=MyPassword;"

-or-

"URL=ResourceURL;User ID=MyUserID;Password=MyPassword;"

The string consists of these keywords:

Keyword

Description

Provider

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.

User ID

Specifies the user name.

Password

Specifies the user password.

NoteNote

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.

NoteNote

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.

Show:
© 2014 Microsoft