I have been asked to set up an automated report to be emailed to management at certain times during the week. I've decided to use SSRS 2005 to do this.
The data source has to be an Excel spreadsheet (i know, I know, not cool, but that's what they want). I set up an Excel system DNS ODBC link on the server that points to a development version of the spreadsheet using the full path name.
In Visual Studio I created a shared data source that doesn't use any credentials. I've written the report using a simple dataset and it works fine within VS2005. I can deploy both the data source and report to the local reporting server without errors.
When I go to run the report from report server I get the following errors:
An error has occurred during report processing.
Cannot create a connection to data source 'orderbook'.
ERROR [HY000] [Microsoft][ODBC Excel Driver] The Microsoft Office Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Excel Driver] The Microsoft Office Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.
No one has the spreadsheet open. I've even closed VS2005 to make sure. I tried giving the data source network admin credentials, but the report still doesn't run. I have even moved the spreadsheet to be stored locally on the server, but to no avail.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a discu…
This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …