PDA

View Full Version : User defined SQL Server Database



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

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

Thank you.

nnjcsc
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?

hidenori
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.

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

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

nnjcsc
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?

hidenori
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.

Regards.