https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/926008&feed=atom&action=history
Microsoft KB Archive/926008 - Revision history
2024-03-29T10:11:50Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/926008&diff=224379&oldid=prev
3155ffGd: importing KB archive
2020-07-18T17:33:27Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB926008"></span>Error message when you create a new Data View in a Windows SharePoint Services 2.0 Web site that connects to an Access database: &quot;The data retrieval service encountered an error during connection to the data source&quot; =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 926008<br />
<br />
Article Last Modified on 5/8/2007<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Windows SharePoint Services<br />
<br />
<br />
-----<br />
<br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
Consider the following scenario. You use Microsoft Office FrontPage to create a custom OLE DB connection from a Microsoft Windows SharePoint Services 2.0 Web site to a Microsoft Office Access database. In Internet Information Services (IIS) Manager, you configure the Windows SharePoint Services 2.0 Web site to use HTTP and HTTPS. In FrontPage, you right-click the new database connection, and then click '''Insert Data View''' to add a new Data View. Then, you save the changes.<br /><br />
<br /><br />
In this scenario, when you use an HTTP connection, such as http://<code>ServerName</code>/Sites/<code>SiteName</code>, to visit the Windows SharePoint Services 2.0 Web site, the new Data View is not displayed.<br /><br />
Additionally, when you use an HTTPS connection, such as https://<code>ServerName</code>/Sites/<code>SiteName</code>, to try to view the Windows SharePoint Services 2.0 Web site, you receive the following error message:<br />
<div class="errormessage"><br />
<br />
The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information.<br />
<br />
</div><br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
This issue occurs because Windows SharePoint Services 2.0 does not support Access databases. By default, the Jet OLE DB provider is disabled in list of OLE DB providers that are supported by Windows SharePoint Services 2.0.<br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
To resolve this issue, upsize the Access database to a Microsoft SQL Server database. For more information about how to use the Upsizing Wizard, visit the following Microsoft Web sites:<br />
<div class="indent"><br />
<br />
http://msdn2.microsoft.com/en-us/library/ms952656.aspx<br />
<br />
<br />
</div><br />
<div class="indent"><br />
<br />
http://msdn2.microsoft.com/en-us/library/aa164896(office.10).aspx<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
This behavior is by design.<br />
<br />
</div><br />
Keywords: kbtshoot kbexpertiseinter kbprb KB926008<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd