How to Fix the Error “2006 – MySQL server has gone away”

Today I was attempting to transfer a MySQL database from one MySQL server to another.  I was using the excellent MySQL client software from PremiumSoft called Navicat.  The transfer kept failing with the following error:

2006 – MySQL server has gone away

When the direct data transfer failed I tried backing up my old [...]

SQL Enterprise Manager: Setting NULL Value

I always seem to forget the key command to set a NULL value while directly editing a table cell in SQL Enterprise Manager.

The command is: CTRL-0 (Just so I know where to get it in case I forget again.)

What use is this?  Well, if you enter a value into a previously NULL [...]

How to get ColdFusion to talk to SQL Express 2005

I’m still in the process of setting up local development environments on multiple computers using the following:

ColdFusion MX 7 (Developer)MS SQL Server 2005 ExpressMySQL 5ApacheEclipse (w/ CFEclipse)

The latest snag came in getting ColdFusion to validate a datasource linking to a SQL Server 2005 Express database.  Googling around eventually turned up an answer, [...]