How to Execute SQL Script while installing databae from InstallShield 2009

[#1]

I am creating a project to install a (MySql) database in InstallShield2009. I want to execute a SQL script when installing the setup.
1) I am using MySQL 4.1.7.
2) I have installed ODBC driver for MySQL 5.1
3) I have created a new connection.
4) I have inserted a sql script and associated its corresponding component with a feature.
5) I have specified {MySQL ODBC 5.1 Driver} in the AdoDriverName column in the ISSQLDBMetaData table in the Direct Editor.
I am able to connect to the database tool. And Installation completed without any error.
But the Scripts are not executed as the script results are not updated in the database.
Please help me to execute the sql script.

ankur

[hidenori]

Would it be possible for you to post a sample project that reproduces the behavior so that I can look into it?

[#3]

Please find the attached zip file. After extraction, you will get the ism file and the project folder containing the script file.

Please try to set the environment, reproduce the issue and suggest some solution. Thank You.

[hidenori]

Please try putting a batch separator as follows and see if it works.

INSERT INTO test.tab VALUES (3);
GO

[#5]

Thank you very much.
The last 'Go' was missing.
It is working now.
Thanks once again.