"Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnycsoftware", or the name is ambiguous."
If you are absolutely sure that you do not have have another function with that name and the function is working fine, you might be getting this error because of a caching issue with microsoft sql managemet studio.
FIX: Close Microsoft Management Studio and reopen the function.
How do I find My Host Key (SSH/WinSCP)?
Log in to the sftp server an run these commands:
ssh-keygen -l -f /etc/ssh/ssh_host_key.pub ssh-keygen -l -f /etc/ssh/ssh_host_rsa_key.pub ssh-keygen -l -f /etc/ssh/ssh_host_dsa_key.pub
// Get a time in the format : 8:00 AM
// Returns the minute difference in integer using the current time
// (only works for the same day but you can modify to work for any date).
ALTER FUNCTION [dbo].[GetMinutesDifference](@JustTime varchar(50))
RETURNS int
AS
BEGIN
DECLARE @MinuteDifference int
Set @MinuteDifference = (SELECT DATEDIFF(minute, CONVERT(SMALLDATETIME, CONVERT(VARCHAR(8), GETDATE(), 112) + ' ' + @JustTime) , GETDATE()))
Return @MinuteDifference
END
OPENVPN can be very tricky to set up but with the right resources the setup is not quite as bad. I tried to follow the OPENVPN manual (http://openvpn.net/index.php/open-source/documentation/howto.html) but before I know it I was completely lost. The subject got real complicated real fast; so naturally I turned to my dear friend GOOGLE and i was not disappointed.
These websites below made the process very easy for me so hopefully they will do the same for you.
OpenVPN Windows HowTo (A little old but very useful) http://www.runpcrun.com/howtoopenvpn How to configure OpenVPN (A little old but very useful) http://www.itsatechworld.com/2006/01/29/how-to-configure-openvpn Also did you know that Microsoft Windows comes with VPN out of the BOX? Check these two videos out
SSL 443 OpenVPN 1194 Microsoft VPN 1723 MYSQL 3306 MSSQL 1433