SQL Server upgrade from Express

To upgrade SQL Server from Express edition to a different edition of the same version follow the steps:

  1. Insert the SQL Server installation media of the new edition you want upgrade to. From the root folder, double-click Setup.exe.
  2. SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

Did my HOW TO help you? Leave a reply.

HOW TO gain access to local drives in RDP

Often when you are connected to a computer in a Remote Desktop Connection (RDP) you need to have access to your local drives or local files.

HOW TO gain access to local drives in RDP?

  1. Click Start, point to All Programs (or Programs), point to Accessories, point to Communications, and then click Remote Desktop Connection.
    Remote Desktop Connection
  2. Click Show Options and then click the Local Resources tab.
  3. Click More under Local devices and resources.
    Remote Desktop Connection - Local Resources
  4. Select the check box next to Drives (you could select some drives clicking the plus sign to show detail data) then click OK.
    Remote Desktop Connection - Choose local devices and resources
  5. Click the General tab, Type the name of the Computer and the Username (with format Domain\Username) and then click Connect.
  6. Type your Password and then click OK.

Did my HOW TO help you? Leave a reply.

Error fetching plugins in WordPress.com

Accessing to your site on WordPress.com, it appears a warning
Warning on WordPress.com
and clicking to the warning will appear the following message:
This site cannot be accessed.
Disconnect Site

This site cannot be accessed. Disconnect Site
If you click on the menu Plugins the error message will be:
Error fetching plugins on YourSiteName
Error fetching plugins

If otherwise when you saw the warning you decided click on Disconnect Site then the error will move to the Plugin in your site that will not be able to connect to WordPress.com and when you will click the button Connect Jetpack a warning will be showed as follows:
Your website needs to be publicly accessible to use Jetpack: site_inaccessible
Error Details: The Jetpack server was unable to communicate with your site [HTTP 403]. Ask your web host if they allow connections from WordPress.com. If you need further assistance, contact Jetpack Support: http://jetpack.me/support/

site_inaccessible

Cause:
Jetpack WordPress plugin is being blocked from accessing the XML-RPC file into your site. You can test the access using a URL like

http://www.yourwebsite.com/xmlrpc.php

Information:
If you contact Jetpack support in their answer will be written

"Unfortunately, blocking XML-RPC is not a great solution for fighting security risks.  It's akin to selling your car because you don't want it to be stolen.

Your site's XML-RPC file is kind of like a communication gateway to your site.  Jetpack, the WordPress Mobile Apps, and other plugins and services will use this file to communicate to your site.  If this is blocked, you will have other issues pop-up down the road for the same reasons.

I would suggest contacting your hosting provider and asking them again to unblock your site's XML-RPC.  The most popular hosting providers out there have managed to find other ways to protect their servers without having to hinder your site and your ability to use services with your WordPress.

If they refuse to make any changes, and if you want to use apps and plugins like Jetpack, I'd suggest looking for a new host."

Considerations:
As suggested by Jetpack support you could ask to your provider to fix this issue but I prefer fix it by myself :-)

Solution:
Add the following lines in your .htaccess file

# BEGIN Unblock XML-RPC
<FilesMatch "xmlrpc.php$">
order deny,allow
allow from all
</FilesMatch>

# END Unblock XML-RPC

to allow access the XML-RPC file to everyone and install a plugin like Disable XML-RPC Pingback to block pingback requests as recommended by Jetpack’s author too (source: https://wordpress.org/support/topic/allow-xmlrpcphp-for-jetpack-only).

Did my solution solve your problem? Leave a comment.

Working with dates in NAV

To work following the standards avoids future issues.

In this post I’d like to suggest a way to convert dates in NAV.

Working with dates in NAV

A date in your system can have different formats depending on the preferences of your country and language.

You can come across different errors, for example Server and Client with different settings or ambiguous date because valid between two different formats (e.g. 05/04/2015 that could be DD/MM/YYYY or MM/DD/YYYY)

To avoid this confusion there is an International Standard that is the standard XML format that returns the date in the following format

YYYY-MM-DD

In NAV you can use the FORMAT Function (Code, Text) with the following declaration:

String := FORMAT(Value[, Length][, FormatStr/FormatNumber])

and using the FormatStr = 9 to return a string in XML format

FORMAT(varDate,0,9);

Note: Leaving the Length = 0 then the entire value is returned.

This example requires that you create the following variables:

Name DataType Subtype
varDate Date

Example:

varDate := DMY2DATE(5,4,2015);
MESSAGE(FORMAT(varDate,0,9));

It will return
Working with dates in NAV

How to convert from a string in XML format back to a field or variable of type Date?

To convert a string in a date in NAV we need to call the EVALUATE Function with the following declaration:

[Ok :=] EVALUATE(Variable, String[, Number])

It’s interesting that also in this function we can use Number = 9 to set that the string expected will be in XML format.

Using the standard XML format you will work in accordance to the standards and the configuration of your Server or Client, language or preference in your system will not affect your work and each date will be converted always in the same manner.

Remind that you can use the same functions and logic working with DateTime.

Did my post help you? Leave a reply.

HOW TO load xml from a file in C/AL

In the following example we are going to: open a file, create an InStream object, create an XmlDocument using the DotNet component and load the xml from the InStream.

This example requires that you create the following variables:

Name DataType Subtype
TestFile File
Istream InStream
XmlDoc DotNet
System.Xml.XmlDocument.'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

HOW TO load xml from a file in C/AL?

TestFile.OPEN('C:\TestFolder\TestFile.xml');
TestFile.CREATEINSTREAM(Istream);

XmlDoc := XmlDoc.XmlDocument();
XmlDoc.Load(Istream);

Did my HOW TO help you? Leave a reply.

Could not load file or assembly Microsoft.Dynamics.Nav.Management.dll HRESULT: 0x80131515

Information
—————————

Could not load file or assembly ‘file:///C:\Program Files\Microsoft Dynamics NAV\70\Service\Microsoft.Dynamics.Nav.Management.dll’ or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)
—————————
OK
—————————

Symptoms:
After an update with a new build of Microsoft Dynamics NAV the Microsoft Dynamics NAV Administration tool does not work showing an error message as above.

Solution:

  1. Move the file Microsoft.Dynamics.Nav.Management.dll from the folder
    C:\Program Files\Microsoft Dynamics NAV\70\Service\

    into your Desktop

  2. Right-click on the file, select Properties and in the General tab push the button at the bottom Unblock
  3. Move the file Microsoft.Dynamics.Nav.Management.dll from the Desktop to the original folder
    C:\Program Files\Microsoft Dynamics NAV\70\Service\

Did my solution solve your problem? Leave a comment.

Google Chrome poor resolution on Windows 8.1

To fix this issue I found two solutions, the first one has been marked as “Preferred” because can fix also multiple issues with other software, the second it’s “Easy” to apply. You can also apply both.

Google Chrome poor resolution on Windows 8.1?

Solution (Preferred):
Download and install your video card and monitor drivers.

Solution (Easy):
Navigate into your user folder

C:\Users\<username>\AppData\Local\Google\Chrome\Application

Right-click on chrome -> Properties -> Compatibility tab -> tick “Disable display scalling on high DPI settings” then restart Google Chrome.

Google Chrome poor resolution on Windows 8.1

Did my solution solve your issue? Leave a comment.