~ overflow ~

Problem:

Windows clipboard stop working from nothing;

Windows <=> VNC (unix) not working;

Using alternate copy/paste keys/methods (ctrl/shift + insert, ctrl+x/v/c) will not help;

Solution:

vncconfig must be open on vnc server client

vncviewer must be configurated to allow clipboard transfers

If you are using Xvnc the default options for the server is to allow clipboard transfers, although you might want to check your config file to make sure it’s right (check man page link below).

You can also install autocutsel to check the debug and make sure it’s working.

On windows you might fall into clipboard issues, cleaning the clipboard at `clipbrd.exe` might not resolve the issue, sometimes  a program keeps the clipboard handler open,  making impossible to write data. There’s a little this program that detects that. You may also get the source code for it at code project link below.

Fun:

During the research on this, someone suggested that windows clipboard is a service and that by restarting it you would fix the problem.

Sources:

ObjectMix.com

XVnc Man page

CodeProject

Autocutsel

Problem:

Date format is wrong on asp.

Solution:

ASP’s LCID (location configuration) is wrong, depending on what is the regional configuration of the machine you’re running your asp into the date format might be different. Thanks to microsoft.

There’s a workaround for this by setting the Session.LCID at global.asa:

Sub Session_OnStart

Session.LCID = 1033

End Sub

Will set the region to English – United States (1033).

You can see a full list on the source I’ve found this information, here.

Full Story:

Datetime formats were wrong on the MSSQL database after the migration, after doing some research I’ve figured out that MSSQL has it’s own datetime format which also might vary depending on the specific windows regional configurations, to know what is the format the MSSQL is running you should query sp_configure ‘default langauge’, config_value column will return the code of the language which you can find by sp_helplanguage, it also has the default datetime format, which you can set on the specific instance by SET DATEFORMAT mdy.