InstallShield/SQL Server problem 1501... 1

[OrthoDocSoft]

Folks,

I've upgraded to SQL Server as my DB solution and am trying to bundle my application and DB as an InstallShield Setup bundle. This used to go perfectly, but since adding the SQL Server DB's I get this error:

fatal error -1501: Could not compress "C:\Program Files\microsoft sql server\mssql10.mssqlserver
\mssql\data\frozens.mdf" into "C:\Program Files\Microsoft Visual Studio\VB98\Macrovision\FN100\Express
\SingleImage\DiskImages\DISK1\Data1.cab

When I look up this error code, I'm advised to run "ISCmdBld.exe" to solve the problem. Can someone explain this to me, and give me advise on how to correct it?

Thanks,

Ortho

"you cain't fix 'stupid'...

 

[JoeAtWork]

You probably need to temporarily take your database offline, since the MDF and LDF files will otherwise be in use and locked by the SQL Service.

In previous versions a couple of ways to do this would be to:
1. Detach the database using the sp_detach_db stored procedure (when you are finished you can bring it online again by running sp_attach_db)
2. Shutting down the whole SQL Server service

But nowadays you can do this in SQL Management Studio by simply right clicking the database and clicking Tasks --> "Take Offline".

 

[OrthoDocSoft]

JoeAtWork,

I just came back to answer my own question, and found that you had done so almost perfectly. I am using MS SQL 2008 and Installshield 11.5 express. I found the following to be true.

You MUST detach the database from MS SQL Server, before your build your setup file in Installshield. Simply closing the service (and leaving the databases attached, as you suggested) produces the Installshield 1501 error. Detaching and then creating the Setup file works great.

Star for you, many thanks, and I have a thought for you; go home, sometime....

Ortho

"you cain't fix 'stupid'...