Configure Reporting Services proxy for Bing maps

›
Add the following XML element to the web.config of both folders: ...\MSSQL\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\ ...\MSSQL\...

Change records per page in Master Data Services

›
To change the number of records/rows per page in the Explorer view of Microsoft Master Data Services (MDS), do the following: Select an en...

Cannot map network drive to Sharepoint library

›
Example error: "Your client does not support opening this list with Windows Explorer" Steps to check beforehand: Add Sharepoin...

Unable to read exported Excel workbook because of illegal character

›
After exporting from reporting services, Excel opens the workbook with one of the following errors: "Replaced Part: /xl/worksheets/sh...
1 comment:

OCR a (region of a) PDF using C# and "freeware"

›
Perform the following steps: 1) Install Ghostscript to make conversion of PDF possible: https://code.google.com/p/ghostscript/downloads/l...

Analysis Services fails with "attribute key cannot be found" on Unicode field

›
ERROR The attribute key cannot be found when processing: Table: 'dbo_viu_isb', Column: 'city', Value: '　'. The attr...

Openrowset fails with "network access was interruped"

›
A SQL Server openrowset query using ODBC to retrieve data from an Excel spreadsheet fails with the error: "Your network access was in...

Packing intervals

›
Solution to the "packing intervals" problem by Itzik Ben-Gan: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals....

Execute query under cursor

›
There is no way in SQL Server Management Studio (SSMS) to execute the query under the cursor. There is the option to execute the entire scri...

Count of weekend days in date range

›
Use the formula in "calc_name" or "calc_df" to calculate the number of inclusive weekend dates in a date range. Inclusiv...

Quipu JDBC connection to MS Access

›
There are several ways to connect to a MS Access database from Java, like the low-level MS Access library called Jackcess: http://jackcess.s...

Uninstall Microsoft Security Essentials

›
Microsoft Security Essentials can be uninstalled from Windows 7 as follows: Download the installer from the Microsoft website (currently: ...

Flash 11.4 in SRWare IronPortable v22

›
To get Flash support in the portable version of Iron v22: Start IronPortable and type "about:plugins" in the URL bar Scroll to ...

Stop Outlook from reformatting telephone numbers

›
A telephone number gets reformatted when adding it to a contact in Outlook, e.g. "+31.." becomes "31". This behaviour ...

Epson AL-C900 with empty color toner

›
The Epson AL-C900 Aculaser has a default setting that makes it impossible to continue printing if one of the color toners/consumables is e...

MS Access DSN-less connection

›
It is possible to create a DSN less linked table and/or pass-through query from Microsoft Access to SQL Server Express without deleting th...

PALO backend is unavailable

›
You might get an "backend is unavailable" error when connecting to the PALO server from an internet page. Check the %SYSTEMDRIVE...

Bamboo Pen & Touch supported driver not found

›
If you try to start the Wacom Bamboo Preferences application, but get an error message displaying "a supported tablet could not be foun...

Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...