InstallShield/MS SQL Server Error 1904...

[OrthoDocSoft]

Folks,

Have upgraded my DB solution to MSSQL Server, and now I am distributing 2 detached MS SQL DB's with my application, to be attached (to MS SQL Server) after installation.

When I install the setup package, at the end I get the error:

Error 1904.Module C:\Program Files\MyCompany\databases\MyDB.mdf failed to register. HRESULT -2147220474. Contact your support personnel.

This repeated for:

MyOtherDB.mdf
MyDB_log.ldf
MyOtherDB_log.ldf

and my original MS Access DB's

MyOriginalAccessDB.mdb, and
MyOtherOriginalAccessDB.mdb.

I tried installing with no other apps running (like MS SQL Server) and that didn't help. When I researched the "2147220474" bit, I found:

Executable file extension, but not actually an executable.

which doesn't make much sense to me, since there is no .exe extension. Does anyone know how to fix this? The DB's appear to be present after the install, but I hate to leave this unresolved.

This is an identical post to one on the MS SQL Server forum.

Thanks,

Ortho


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

 

[OrthoDocSoft]

Figured it out myself, so I will answer it for the board's sake.

The problem is that the databases were "dynamically linked" in InstallShield (you InstallShielders will know what I am talking about). So I deleted that folder (databases), created another (same name) and dragged and dropped the DB's into it.

Worked like a charm! Errors went away. Can I give myself a star?

Ortho

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