Hi. I have finished a web-site - and it runs fine on my dev machine. I
have deployed it onto the server, and now I have this (which, by the
way, doesn't seem to happen all the time - sometimes I can see other
errors):
_______________________________________________
Description: An error occurred during the processing of a
configuration file required to service this request. Please review the
specific error details below and modify your configuration file
appropriately.
Parser Error Message: An error occurred loading a configuration file:
Failed to start monitoring changes to '\\d49\wwwsites$\SOPDEV
\app_code' because the network BIOS command limit has been reached.
For more information on this error, please refer to Microsoft
knowledge base article 810886. Hosting on a UNC share is not supported
for the Windows XP Platform.
Source Error:
[No relevant source lines]
Source File: \\d49\wwwsites$\SOPDEV\app_code\web.config Line: 0
_______________________________________________
My app needs to load three excel files on start-up - two from a
subfolder of the webfolder (subfolder named "Other Files"), and one
from a shared network drive. I load them into my SQL server by calling
some stored procedures, which, when executed from within SQL server,
run great. They also work great when executed on my dev machine, as
I've said.
This is not relevant, but here is an example of such a sproc, which
loads an external excel file into the "ManagerReport" table: <snip>
______________________________________________
CREATE PROCEDURE [dbo].[ImportManagerReport]
@Filename varchar(200)
AS
BEGIN
SET NOCOUNT ON;
DBCC CHECKIDENT(ManagerReport, RESEED, 0)
DELETE FROM ManagerReport
DECLARE @Sqlstring varchar(4000)
SET @SQLString = 'SELECT [PIN], [First Name], [Last Name], [Record
Added Date], [CostCenter],
FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data
Source="' + @FileName + '";Extended properties=Excel
8.0'')...ReportAccumulator$ ORDER BY [Record Added Date], [PIN]'
PRINT @SQLString
EXEC(@SQLString)
INSERT INTO ManagerReport EXEC(@SQLString)
END
_______________________________________________
I'm working in a big company, paranoid about security, and I don't
control the server - I've had to go through a lot of 'help desk'
bureaucracy to obtain the SQL Server instance on the server, the
webfolder, and the necessary rights. As I've said, when I run this
sproc manually, from the instance of SQL server on the server, it
works like a charm. Whenever I call it from within ASP, it fails with
the message written above, or sometimes (randomly, it appears), a
message similar to this:
_______________________________________________
Exception Details: System.Data.SqlClient.SqlException: Cannot open the
table "ReportAccumulator$" from OLE DB provider "Microsoft.Jet.OLEDB.
4.0" for linked server "(null)". The specified table or view does not
exist or contains errors.
Checking identity information: current identity value '9', current
column value '0'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
SELECT [PIN], [First Name], [Last Name], [Record Added Date],
[CostCenter] FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data
Source="\\my network path....\ReportAccumulator.xls";Extended
properties=Excel 8.0')...ReportAccumulator$ ORDER BY [Record Added
Date], [PIN]
_______________________________________________
The ReportAccumulator.xls is produced by some other apps in our
company. I've searched hi and low - I'm stuck here, and the VP is
waiting to see the site in production :-(((((((( Could somebody help,
please !
Thanks a lot.
Alex.