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: Problem Setting up MYSql Database
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jun 24, 2008
02:10 PM
Problem Setting up MYSql Database
Hi
I have created server in database server option. Then I have added scripts to execute when installation is running. I have problem is that I can connect to mysql server and database perfectly, but after that it checks script but no table has been made in database. If I have problem in my script then it shows me error, but everything is fine, but still its not setting up database.
Another thing is that In Script tab if I give multiple line in different line then it shows me error that MYSql Script has error please check that. I dont have error but its not considering newline. Is that true that I have to write all script in one line not multiple line? means like
CREATE DATABASE data;DROP TABLE IF EXISTS `dataview`;
If I put newline between two sentance it gives me error. Please provide me solution.:confused: I cant setup database. Please tell me whats problem I have.
I have database connection dialog and its connection working perfectly. because it doesnt giving me error. Help Please.
I have created server in database server option. Then I have added scripts to execute when installation is running. I have problem is that I can connect to mysql server and database perfectly, but after that it checks script but no table has been made in database. If I have problem in my script then it shows me error, but everything is fine, but still its not setting up database.
Another thing is that In Script tab if I give multiple line in different line then it shows me error that MYSql Script has error please check that. I dont have error but its not considering newline. Is that true that I have to write all script in one line not multiple line? means like
CREATE DATABASE data;DROP TABLE IF EXISTS `dataview`;
If I put newline between two sentance it gives me error. Please provide me solution.:confused: I cant setup database. Please tell me whats problem I have.
I have database connection dialog and its connection working perfectly. because it doesnt giving me error. Help Please.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jun 25, 2008
12:25 PM
Is your custom database created, but a table not created under the database? If so, remove the CREATE DATABASE statement from your script and use the "Create Catalog If Absent" option available on the General tab instead. You also need to specify your database name in the Catalog Name field.
When you split SQL statments in multiple line, you need to specify ; in the Batch Separator setting on the Advanced tab of your connection.
Hope that helps.
When you split SQL statments in multiple line, you need to specify ; in the Batch Separator setting on the Advanced tab of your connection.
Hope that helps.