Thursday, February 24, 2011

Error in Silverlight Application Code: 2104 Category: InitializeError Message

If you are trying to display your Silverlight project on a browser and you get the next error:

The error maybe due to MIME types. You will have to add the following MIME types:
.xaml    application/xaml+xml
.xap    application/x-silverlight-app
.xbap    application/x-ms-xbap
 

To do so:
  • Open your web site on IIS
  • Right click on it and select properties

  • Select the HTTP Headers
  • Click on MIME Types

  • Click the New button

  • Add all the MIME types
  • Click OK
  • Click Apply


Monday, February 21, 2011

Error code 2869 in windows 7

If you are trying to install an application in Windows 7 or Vista, and you get  the error:


The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2869

Follow the next steps to solve the problem:

  • Right click the .exe file
  • From the menu select run as administrator
  • Follow the instructions to install your program

Friday, February 18, 2011

Sterling Commerce - Missing GTIN Information when GTIN is already there

If you get the next error when submitting your toolkit:


Description:
If a GTIN is found either on the Global, Target Market or Data Recipient, it must be listed on all three tabs along with any applicable extension tab (Hardlines / Lowe's / AVP). 
Steps to Rectify:
Missing GTIN needs to be added to the Target Market and/or Data Recipient tab. 
Item Number
GTIN
Retailer
Market
Invalid Data
00019374967420 
Target Market Data Missing for GTIN = 00019374967420 

The problem is that there is a blank space at the end of the GTIN, just remove it thenresubmit the Toolkit.

Sterling Commerce - Invalid quantities

If you get the next error or something alike, when submitting a toolkit:



Description:
Quantity entered on the Link Tab does not agree with the quantity supplied on the Global field - Total Quantity of Next Lower Level Trade Item
Steps to Rectify:
Review value entered on the Global tab for Total Quantity of Next Lower Level Trade Item. If this value is correct update the quantity for this Trade Item on the Link tab to reflect the same value. If the value originally entered on the Global tab is incorrect update accordingly and verify that the same value is supplied on the Link tab.
Item Number
GTIN
Retailer
Market
Invalid Data
70000000000001
Total Quantity of Next Lower Level Trade Item = 12, Total Quantities from Item Link = 24


The problem most likely is because your I2 of 5 was previously registered with a different UPC child element. Search your I2 of 5 and UPC and verify if it was used before.


Thursday, February 17, 2011

How to convert Footnotes to Endnotes and vice versa

If you want to How to convert Footnotes to Endnotes and vice versa follow the next steps:

  1. Launch the Footnote and Endnote menu
  2. Select the button Convert in the Location section
  3. The Convert Notes window will be showed
  4. Select the option Convert all footnotes to end notes (or Endnotes to Footnotes)
  5. Click Ok

How to reuse a Footnote in word

If you want to reuse a footnote in a word document, follow the next steps:

  1. Put the cursor where you are going to use the footnote
  2. Go to References >> Cross-reference, a dialog box will open
  3. From the Reference type select the option Footnote
  4. Select the Footnote you want to reuse
  5. Check the box Insert as hyperlink if you want to make reference to the original one
  6.  Click the Insert button

Tuesday, February 8, 2011

How To Remove Add-in Icons From the 2007 Excel Ribbon

In order to remove Add-in icons from the 2007 Excel ribbon you need to delete or rename the xlb file


  1. Got to C:\Users\%UserProfile%\AppData\Roaming in Windows 7 or to  C:\Documents and Settings\%UserProfile%\Application Data in Windows XP
  2. Locate the file Excel12.xlb and rename it
  3. By deleting or renaming this file Excel will create a new one
  4. Run again Excel and the options should be there
Deleting the file or renaming will do no harm to your system
Excel will create a new file for you. (You lost only your customization)
If you make your own toolbars or add buttons to the others this file is important (backup it so you can restore it)

Unable to delete rows on Excel, option is grey out

If you are unable to delete rows or change the format because the option is disabled, looks like one macro or one update changed the configuration profile file of the Excel.
To fix this problem follow the next steps:

  1. Got to C:\Users\%UserProfile%\AppData\Roaming in Windows 7 or to  C:\Documents and Settings\%UserProfile%\Application Data in Windows XP
  2. Locate the file Excel12.xlb and rename it
  3. By deleting or renaming this file Excel will create a new one
  4. Run again Excel and the options should be there

Junction Points in Windows

A Junction Point is a physical location on a local hard disk that points to another location on that disk or another storage device. It is essentially a shortcut.
For the most part, you can ignore Junction Points for everyday use of Windows Vista. The Junction Points are in Vista for backward compatibility of pre-Vista applications. Pre-Vista applications (applications written for XP and 2000) look for folders that are no longer used in Vista. Folders with the “My” prefix such as My Documents, My Pictures, and so on.

Junction points can be identified as follows :
They have the FILE_ATTRIBUTE_REPARSE_POINT, FILE_ATTRIBUTE_HIDDEN, and FILE_ATTRIBUTE_SYSTEM file attributes set.
They also have their access control lists (ACLs) set to deny read access to everyone.

User Profiles in Windows Vista
In Windows XP, 2000, 2003, user profiles are stored under c:\Documents and Settings. In Windows Vista (and the soon to be Windows Server 2008 – Longhorn), profiles are now stored under c:\Users. You will see a c:\Documents and Settings folder in Windows Explorer in Vista, but you will also notice the shortcut icon on this folder, and you will not be able to access this folder. c:\Documents and Settings is now a Junction Point. You can use the dir /aL command to see where c:\Documents and Settings points to or use the table below.
The following table lists the old profile path and the corresponding new path under Windows Vista/Longhorn Server.


Old PathNew Path
\Documents and Settings\Users
\Documents and Settings\Default User or
%LOGONSERVER%\NETLOGON\Default User
\Users\Default or
%LOGONSERVER%\NETLOGON\Default
\Documents and Settings\\My Documents\Users\\Documents
\Documents and Settings\\My Documents\My Pictures\Users\\Pictures
\Documents and Settings\\My Documents\My Music\Users\\Music
\Documents and Settings\\Favorites\Users\\Favorites
N/A\Users\\Contacts
N/A\Users\\Downloads
N/A\Users\\SavedGames
\Documents and Settings\\Application Data\Users\\AppData\Roaming
\Documents and Settings\\Local Settings\Application Data\Users\\AppData\Local
\Documents and Settings\\Start Menu\Users\\AppData\Roaming\Microsoft\Windows\ Start Menu
\Documents and Settings\All Users\Users\Public
\Documents and Settings\All Users\Start Menu\ProgramData\Microsoft\Windows\Start Menu
\Documents and Settings\All Users\Desktop\Users\Public\Desktop


Folders to take note of here are the folders in the All Users path. Many older applications that use out of date methods to resolve system folders, will resolve paths under C:\ProgramData when looking for common locations. For example, the common desktop may be resolved as C:\ProgramData\Desktop, however; this is actually a junction point for C:\ProgramData\Users\Public\Desktop. A dir /aL listing in the C:\ProgramData folder reveals the following Junction Points:

PathPoints To
\ProgramData\Application Data\ProgramData
\ProgramData\Desktop\Users\Public\Desktop
\ProgramData\Documents\Users\Public\Documents
\ProgramData\Favorites\Users\Public\Favorites
\ProgramData\Start Menu\ProgramData\Microsoft\Windows\Start Menu
\ProgramData\Templates\ProgramData\Microsoft\Windows\Templates



Environmental Variables
There are also differences in environment variables between Windows Vista and the older versions of Windows. Windows Server 2003 and below define the following variables relating to profiles:

ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\bjohnson\Application Data
HOMEPATH=\Documents and Settings\bjohnson
TEMP=C:\DOCUME~1\bjohnson\LOCALS~1\Temp
TMP=C:\DOCUME~1\bjohnson\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\bjohnson

Windows Vista and Longhorn Server define the same variables while adding a couple more.

ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\bjohnson\AppData\Roaming
HOMEPATH=\Users\bjohnson
LOCALAPPDATA=C:\Users\bjohnson\AppData\Local
ProgramData=C:\ProgramData
PUBLIC=C:\Users\Public
TEMP=C:\Users\bjohnson\AppData\Local\Temp
TMP=C:\Users\bjohnson\AppData\Local\Temp
USERPROFILE=C:\Users\bjohnson


Source:
http://www.svrops.com/svrops/articles/jpoints.htm

Application Data Folder

The Application Data Folder is part of your user profile. It is customedized controls for the programs that have been installed for the user. Programs such as Outlook and Outliook express can store their mail databases there. It is not a good idea to remove anything from there.
In this folder applications store their files your settings and much more.

On Windows XP you can find this folder on the path:
C:\Documents and Settings\%UserProfile%\Application Data



On Windows 7 the Application Data is not an actual folder, it is a Junction which is only there for backward compatibility. A Junction is a shortcut that redirects files and programs to a different location. You can find the Application Data junction in the next path:
C:\Users\%UserProfile%\AppData\Roaming





Tuesday, February 1, 2011

Linked Server Error: Server 'MyServer' is not configured for RPC

If when you are trying to connect to a 2000 SQL server from 2005 you get the error:

Msg 7411, Level 16, State 1, Line 100
Server 'MyServer' is not configured for RPC.

You need to configure the RCP for your linked server, run the next command to be sure the RCP is not part of your server configuration:

-- Shows all your servers and the configurations 
exec sp_helpserver
------------------------------------------------



If the RCP is not there run the next commands to enable it:

-- Enables the RCP options
exec sp_serveroption @server='MyServer', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='MyServer', @optname='rpc out', @optvalue='true'
------------------------------------------------------------------------------



You can also enable this option from the SQL Server Managment Studio:

  • Righ click on your linked server
  • Select properties
  • On the "Select a page" option click on "Server Options"
  • Be sure Rcp and Rcp Out are True