This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Running SQL script from InstallShield 2009
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
Not applicable
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 08, 2009
08:53 AM
Running SQL script from InstallShield 2009
I have a SQL script and I have MySQL server installed in my machine. I want to run this SQL script from InstallShield 2009 setup. I am not able to connect MySQL with InstallShield 2009.
I have created a feature and associate this script with this feature.
During Installation, I am getting a window to give Database Server. After giving Database Server, its giving ODBC error. I dont know what to give in database Server name. Please help.
ankur
I have created a feature and associate this script with this feature.
During Installation, I am getting a window to give Database Server. After giving Database Server, its giving ODBC error. I dont know what to give in database Server name. Please help.
ankur
(5) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 08, 2009
12:07 PM
If you add a connection and a script in the SQL Scripts view, make sure that you only select the "MySQL" checkbox in the Requirements tab. Please also make sure that you have a MySQL ODBC driver installed on your target machine. In the Server Name field on the SQLLogin dialog, you need to specify a MySQL server name that you want to connect to. If you target a local server, you can use 'localhost'.
Hope that helps.
Hope that helps.
Not applicable
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 11, 2009
02:36 AM
Thanks for your solution but the problem is not resolved completely.
I downloaded MySQL ODBC driver mysql-connector-odbc-5.1.5-win32.msi and installed in my destination machine.
I created ODBC Data Source Name for it.
While running Setup.exe from the build created, in the "Database Server" window, after giving the Database Server as created and the authentication credentials, I am getting the following error
"There was an error in to MySQL.
Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)"
Please help.
ankur
I downloaded MySQL ODBC driver mysql-connector-odbc-5.1.5-win32.msi and installed in my destination machine.
I created ODBC Data Source Name for it.
While running Setup.exe from the build created, in the "Database Server" window, after giving the Database Server as created and the authentication credentials, I am getting the following error
"There was an error in to MySQL.
Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)"
Please help.
ankur
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 11, 2009
10:55 AM
InstallShield is currently designed to work with the MySQL Connector/ODBC 3.51 driver. Please follow the steps below in order to use the MySQL Connector/ODBC 5.1 driver in InstallShield:
[LIST=1]
Go to the ISSQLDBMetaData table in the Direct Editor.
Find the MySQL entry.
Change the value of the AdoDriverName column to {MySQL ODBC 5.1 Driver}.
Rebuild your setup.
If you want to support both versions, you need to specify {MySQL ODBC 3.51 Driver};{MySQL ODBC 5.1 Driver} in the AdoDriverName column. InstallShield will try to connect using 3.51 first. If the driver is not found, then it will try 5.1.
Hope this helps.
[LIST=1]
If you want to support both versions, you need to specify {MySQL ODBC 3.51 Driver};{MySQL ODBC 5.1 Driver} in the AdoDriverName column. InstallShield will try to connect using 3.51 first. If the driver is not found, then it will try 5.1.
Hope this helps.
Not applicable
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 12, 2009
06:41 AM
This works. Thank You. I am able to do connectivity. The errors coming earlier are resolved.
But my sql script is not executing. I mean to say I have written a very simple sql script to insert some values into a table. This script I have inserted in the SQL wizard. After running setup.exe, the table is not updated with the latest values. Even I am creating a table in the same script. It is also not created. it means the script is not executed.
Please help.
ankur
But my sql script is not executing. I mean to say I have written a very simple sql script to insert some values into a table. This script I have inserted in the SQL wizard. After running setup.exe, the table is not updated with the latest values. Even I am creating a table in the same script. It is also not created. it means the script is not executed.
Please help.
ankur
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 12, 2009
09:50 AM
I would suggest that you generate a Windows Installer verbose log for the installation to check whether the script is executed or not. If it is NOT executed, you may be able to find out what is causing it from the installation log. If executed, please make sure that you are verifying on the correct database catalog. If you are using a GUI tool for the verification, you may need to refresh it manually.