SSL 443 OpenVPN 1194 Microsoft VPN 1723 MYSQL 3306 MSSQL 1433
Add a Mysql as a Linked Server
The other day I got a request to migrate some data from Mssql to Mysql. I am like ok fine, I will just use SSIS and it will take me a second.
This second led to more than four hours of frustrations. Why? Apparently Microsoft decided not to put any ODBC destination connectors on
the SQL Server Intelligence Studio (SSIS – 2005 version).
Note that my evironment consists of the sql server 2005, bids (2005) .
FYI: It seems that on the 2008 version, Microsoft gives us the ODBC provider back.
If you are still running the 2005 version here are the solutions:
Setup SQL Server Linked Server to MySQL
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
Adding Mysql as a linked server
http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_server_in_MS_SQL_Server
Insert into a MYSQL linked Server
http://www.youdidwhatwithtsql.com/insert-data-mysql-tsql/4
Format date and time MS DOS
This is a quick MSDOS Batch script to help me out when I have to move a file and rename it in the process based on the current date.
cls
FOR /f "tokens=1-4 delims=/-. " %%G IN ('date /t') DO (call :Fix_Date %%G %%H %%I %%J)
goto :print_date
:Fix_Date
if "%1:~0,1%" GTR "9" shift
FOR /f "skip=1 tokens=2-4 delims=(-)" %%G IN ('echo.^|date') DO (
set %%G=%1&set %%H=%2&set %%I=%3)
goto :eof
:print_date
copy c:\Users\ycsoftware\ycsoftware.txt c:\ycsoftware.%mm%.%dd%.%yy%.txt
Set up a VPN using Microsoft Windows
1.First Look at this video to set up the server
2. Then this one to set up the client
Note that these are not ycsoftware.net videos, they have been selected from youtube because they summarize really what i wanted to write about, which is: How to set up vpn on windows.
If you prefer to read, check this site out:
http://www.aeonity.com/frost/howto-windows-xp-vpn-server-setup
FYI: The Default VPN Port on Windows is 1723
Issues
Loosing internet connectivity when vpn is on
http://footheory.com/blogs/shane/archive/2007/08/14/vpn-connection-disconnects-your-internet-session.aspx
Mute and UnMute Sounds with Flash (action script 2.0)
Add the followings to your buttons.
To mute all sounds
on (release) {
var PlayingSound:Sound = new Sound();
PlayingSound.setVolume(0);
}
To Un-mute all Sounds
on (release) {
var PlayingSound:Sound = new Sound();
PlayingSound.setVolume(100);
}