I was very happy when I heard that Microsoft has released a BDC XML file creator application called Microsoft Business Data Catalog Definition Editor ( MBDCDE ) with SharePoint 2007 SDK 1.2. But my happiness did not last long 
.
I have started the installation, but at the end of the installation I got this error: "Unexpected Error has occured. Error is 'ExecuteNonQuery failed for Database '…'. ' –> ExecuteNonQuery failed for Database '…'. –> An exception occured while executing a Transact-SQL statement or batch. –> Invalid column name 'id'.".
SQL Server 2005 Express Edition ( SQLExpress ) is a prerequisite for MBDCDE. When you start the installation of MBDCDE, it searches for the SQLExpress instance named "BDC". If it cannot find the instance it starts the unattended installation of SQLExpress. When it comes to the collation of the SQLExpress installation, the setup sets the collation of the SQLExpress instance according to the regional setting of the computer. In my example, my regional setting was Turkish, so the collation of the SQLExpress instance was set as Turkish_CI_AS. After the installation of the SQLExpress instance, MBDCDE installation starts, and it gives the error above because of the inappropriate collation.
As a solution for the problem, I have installed SQLExpress manually, so I could set the default collation of the installation as Latin1_General_CI_AS with the builtin wizard. I have set the instance name as "BDC" ( the name of the instance is very important ). After the SQLExpress installation, I started the MBDCDE installation, it skipped the SQLExpress installation part ( because it found an SQLExpress instance named "BDC" ) and continued with the MBDCDE installation; so the problem was solved.
And now, I am playing with my new tool. 
kurtlubakla