https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/296711&feed=atom&action=history
Microsoft KB Archive/296711 - Revision history
2024-03-28T22:49:35Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/296711&diff=162329&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:36:28Z
<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="KB296711"></span>PRB: &quot;Unspecified error&quot; Error 7399 Using OPENROWSET Against Jet Database =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 296711<br />
<br />
Article Last Modified on 12/1/2003<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft SQL Server 2000 Standard Edition<br />
* Microsoft SQL Server 7.0 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q296711<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
When you run a query by using the OPENROWSET function against a Jet database, this error message occurs:<br />
<div class="errormessage"><br />
<br />
Server: Msg 7399, Level 16, State 1, Line 1<br /><br />
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.<br /><br />
[OLE/DB provider returned message: Unspecified error]<br />
<br />
</div><br />
<br /><br />
This problem also occurs with any linked server query that uses the Jet provider, such as the OPENQUERY function or the Transact-SQL query with four-part names.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
The Jet engine needs to create temporary files. To create the temporary files, the Jet engine uses the TEMP and TMP system environment variables. If the TEMP and TMP system environment variables do not exist, Jet uses the %WINDIR% folder. If the SQL Server service account does not have permissions to create, write, delete and read files in the %WINDIR% folder, or to the folder pointed to by the TEMP or TMP system environment variable, the error occurs.<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
To work around this problem, use of the the following two methods.<br /><br />
<br /><br />
'''Method 1'''<br /><br />
<br />
# Configure the TEMP and TMP system environment variables to point to a folder (for instance, C:\TEMP).<br />
# Set the permissions to the SQL Server service account on this folder as Full Control.<br />
# Restart the server.<br />
<br />
<br /><br />
'''Note''' In addition to granting full control to the SQL Server service account, any user that connects to the computer that is running SQL Server by using Windows Authentication must also be granted full control to the same TEMP and TMP directories that the SQL Server service account uses. Before you instantiate the OLEDB provider, SQL Server impersonates the account that is connecting to the computer that is running SQL Server if it is using a trusted connection.<br /><br />
<br /><br />
'''Method 2'''<br /><br />
<br />
* If there is not a TEMP or TMP system environment variable, set the permissions to the SQL Server service account on the %WINDIR% folder as Full Control -or-<br /><br />
<br /><br />
<br />
* Make the SQL Server service account a member of a group that has such permissions on the %WINDIR% folder.<br />
<br />
<br />
</div><br />
Keywords: kbprb KB296711<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