View Full Version : User defined SQL Server Database

04-19-2006, 03:20 PM
Can SQL Server database be user defined at installation?

04-22-2006, 04:46 PM
Could you provide more details what you would like to accomplish?

Thank you.

04-24-2006, 12:40 PM
The user installing the application, enters the database name in a field in a dialog. When InstallShield builds the database, the name of the database, is the name entered by the user.

The "user defines" the name of the database.

Does that answer your question?

04-24-2006, 02:57 PM
If you use the "Create Catalog If Absent" option, you need to create a custom runtime dialog with a edit box that links to IS_SQLSERVER_DATABASE property for Basic MSI and InstallScript MSI projects.

For InstallScript projects, replace SQLRTConnect2() with SQLRTConnectDB( szConnection, szDB, szServer, bWinLogin, szUser, szPassword ) in OnSQLServerInitialize() event. You need to pass a user-defined database name as szDB.

Hope this helps.

04-24-2006, 03:02 PM
Where is the "Create Catalog If Absent" option located?

04-24-2006, 03:05 PM
The check box is located just below the Catalog Name edit field on the Connection | General tab.

04-24-2006, 03:21 PM
Thanks. I found the box.

I do not see any documentation on SQLRTConnectDB function. This should be documented.

What if I have multiple databases?

04-24-2006, 03:58 PM
You can specify multiple databases by separating them with semi-colons ';'. Also, I filed the work order #IOC-000006014 for the documentation issue of the SQLRTConnectDB function.