SSRS Login failed for unattended execution account
08-May-1313 Leave a comment
SOLVED
> Start > All Programs > Reporting Services Configuration Manager
> Connect
> Execution Account
> Put in new Account + Password
WinForms Designer fails – warning …My.Resources.Resources has no property named … image
02-May-1313 Leave a comment
SOLUTION from Dave Anson C comment
In the project References folder ensure there isn’t a reference to itself. (E.g. You have a project named WindowsApplication1. In the References folder you have a reference to WindowsApplication1)
This worked for me.
SSMS viewInfo error with no database list shown
16-Apr-1313 Leave a comment
PROBLEM
Opened SSMS 2012 and got error viewInfo. Unable to see database list.
On Refresh databases same error.
SOLUTION
For me it was to do a restore back 2 days
BACKGROUND
Others have had this.
Sysinternal Tools and filters to “Process Name is ssms.exe” and “Path contains AppData\Local\Temp”
It seemed to not be finding an Addin.
https://connect.microsoft.com/SQLServer/feedback/details/573771/value-cannot-be-null
T-SQL unable to CAST text to a number – Byte order mark – Dodgy character at start
14-Mar-1313 Leave a comment
Scenario
Imported some data from Excel in form “156 x 54 x 16mm”. Parsed the text to get the 156. However this would not convert to a numeric.
Error converting data type nvarchar to numeric
After some exploration I discovered that the cursor required to steps through before the number. So a character was there that SQL Server could not display. To find this I used:
SELECT Code, UNICODE(LEFT(DimensionsTextImport, 1)) AS UnicodeTest FROM Product.<tablename>
And discovered text which would not convert had Unicode 65279
Solution
Create a new column and fill this with the data from the first column after a CASE statement.
UPDATE Product.Dimensions
SET DimensionsText = CASE
WHEN UNICODE(LEFT(DimensionsTextImport, 1)) = 65279 THEN SUBSTRING(DimensionsTextImport, 2, 50)
ELSE DimensionsTextImport END
With reference to:
http://stackoverflow.com/questions/6441208/unable-to-replace-char63-by-sql-query
http://www.fileformat.info/info/unicode/char/feff/index.htm
http://en.wikipedia.org/wiki/Byte_Order_Mark
Cannot use adobe reader to view pdf in your browser. Reader will now exit. Please exit your browser and try again.
07-Mar-1313 Leave a comment
PROBLEM:
- Windows 7 64-bit
- Internet Explorer 9
- Adobe Reader 8.3.1
When opening a pdf in i.e
“Cannot use adobe reader to view pdf in your browser. Reader will now exit. Please exit your browser and try again.”
With reference to:
http://forums.adobe.com/thread/511010
Uninstall version 8.3.1 and install latest. For me this was 11.x.x
Outlook Expand Group fails. Cannot perform the requested operation.
25-Feb-1313 Leave a comment
Problem
Outlook Expand Group fails. Cannot perform the requested operation. The command selected is not valid for this recipient. The Operation failed.
Solution
Outlook > Contacts > Open Group > Update Now
One or more members of this contact group cannot be found…
An error occurred generating a bootstrapper: Unable to begin updating resource for bin\Debug\app.publish\setup.exe with error 80070002 TESTPUBLISH
17-Jan-1313 Leave a comment
ERROR
An error occurred generating a bootstrapper: Unable to begin updating resource for bin\Debug\app.publish\setup.exe with error 80070002 TESTPUBLISH
A SOLUTION to get it to work
Untick the Prerequisites button
See also:
Crystal Reports – Invalid Argument provided. Failed to open a rowset. Error in File Invalid argument for database
17-Jan-1313 Leave a comment
At first thought it ran OK in Crystal not when called from program.
Then checked that it ran from the program on the Crystal developer machine OK.
So runs OK on developer’s machine not on particular user’s machines.
Hence error with ODBC. Changed developer machine ODBC to use from SQLNCLI to SQL Server Native Client 10.0 i.e. SQLNCLI10 and then went to report and “Set Location” for the newest table, the report then worked on all machines
[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified
15-Jan-1313 Leave a comment
ERROR
Have an old Excel file that connects to a database list using Microsoft Query. An existing user was moved to a new Windows 7 machine and then got this error.
[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified
SOLUTION
Tried various things. In the end.
In Administrative Tools > ODBC > Drivers on his machine SQLNCLI was missing.
I did not want to install this old version, so initially changed the connection string to “SQL Server Native Client 10.0” but “SQLNCLI10” may work
Location of Word Startup Macros .dot file
18-Dec-1212 1 Comment
For Word 2003 on Server 2008 I was having an issue whereby the <MyMacrosFile>.dot was not loading on Startup of Word. This was because I had put the file in the Templates location of Server 2008 not the Startup location.
SOLUTION
In Word 2003 Tools > Options > File Locations
The length is limited, so select Startup and press Modify button to see full directory. Put the <MyMacrosFile>.dot file in here.
Seems unnecessary to have a blog entry, but this has caused me some minor lost time, as I while the file was in Templates, I was able to then load it, but this was a little time consuming.
Stephen Shakespeare 