PDA

View Full Version : SQL Connection-Dynamic Catalogue name



Thiyagu
07-09-2005, 02:28 PM
Hi,
Is it possible to give Catalogue name for a SQL connection dynamically during installations?

Thanks,
Thiyagu

Iritbachar
07-13-2005, 09:09 AM
Hi Thiyagu,

Yes, you can give Catalogue name by using:
MsiSetProperty( ISMSI_HANDLE, "IS_SQLSERVER_DATABASE", sDBName );
in the sDBName enter the value you want to enter.
;)
regards,

Thiyagu
07-15-2005, 05:56 PM
Hi Iritbachar,
Thanks for your reply.
I used InstallScript project. I think MsiSetProperty can be used only in the Windows installer. Is there any other way to do it in InstallScript project?

Thanks Again,
Thiyagu

hidenori
07-16-2005, 02:57 PM
In an InstallScript project, you can use SQLRTConnectDB( szConnection, szDB, szServer, bTrust, szUserName, szPassword ) instead of SQLRTConnect() to specify a database that you want to connect to.