IT and business subjects
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
14-Mar-1313 Leave a comment
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
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
07-Mar-1313 Leave a comment
PROBLEM:
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
06-Mar-1313 Leave a comment
If there is a database picture this may need to be re-imported
25-Feb-1313 Leave a comment
Outlook Expand Group fails. Cannot perform the requested operation. The command selected is not valid for this recipient. The Operation failed.
Outlook > Contacts > Open Group > Update Now
One or more members of this contact group cannot be found…
17-Jan-1313 Leave a comment
An error occurred generating a bootstrapper: Unable to begin updating resource for bin\Debug\app.publish\setup.exe with error 80070002 TESTPUBLISH
Untick the Prerequisites button
See also:
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
15-Jan-1313 Leave a comment
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
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
07-Jan-1313 Leave a comment
Because of some work we were doing I lost my TFS connection. When I logged in again I used the wrong account. I did not know how to connect to a different account. Disconnect and connect took me back to same account.
Solved with thanks to:
This had images as well. Text copied here in case link breaks
Click on the connection you want to modify. Remove from vault. Or Edit worked for me.
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 