Which SQL2K Merge Modules do I use ...

Hi,

I want to be able to create a database on a remote SQL Server 2000 during my installation. I use SQL-DMO and a VBScript deferred CA. The script works fine on a Win2K Server with SQL 2000 installed.
What I would like to know is which merge modules I have to distribute from the SQL2K CD to be able to connect to a remote database using SQL DMO? Right now I use DMO.MSM, DMO_RES.MSM, CONNECT.MSM, SQLBASE.MSM. My IE version - or more acurately shdocvw.dll file version - is 5.0.3214.2000, which should be sufficient. Still I keep getting the UI screen that my app's installation was interrupted. BTW (OT), where is the log of my installation written?

Any clues as to why would be nice.

Configuration: W2KServer with SP1, US English(1033), all critical updates installed using Windows Update.

P.S. I already have the latest hotfix for the problem discussed in Q274244. I also cleared up the problem regarding 'Merge Modules Dependencies Can't Be Resolved'.

Hi,

I must state one thing: I do not have a SQL Server 2K running on the PC I use to build my solution. I do have client connectivity and SQL DMO support...

I finally had the common sense to enable the logging option, and I came about something very interesting:
...
Action 16:27:57: AppSearch. Searching for installed applications
AppSearch: Property: IIS5ISINSTALLED, Signature: INETINFOSIG
AppSearch: Property: APPIE.2D02443E_7002_4C0B_ABC9_EAB2C064397B, Signature: F_IE.2D02443E_7002_4C0B_ABC9_EAB2C064397B
AppSearch: Property: APPMSDE7.2D02443E_7002_4C0B_ABC9_EAB2C064397B, Signature: RegMSDE7.2D02443E_7002_4C0B_ABC9_EAB2C064397B
AppSearch: Property: APPMSDE7DATA.2D02443E_7002_4C0B_ABC9_EAB2C064397B, Signature: RegMSDE7Data.2D02443E_7002_4C0B_ABC9_EAB2C064397B
AppSearch: Property: IEINSTALLED, Signature: _IESig
Action ended 16:27:57: AppSearch. Return value 1.
Action start 16:27:57: DefaultProgramDir.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 16:27:57: DefaultProgramDir.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
Action start 16:27:57: DefaultDataDir.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 16:27:57: DefaultDataDir.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
Action start 16:27:57: GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Loading extended custom action library sqlcax.dll
Error 126 loading library sqlcax.dll
Action ended 16:27:57: GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3.
Action start 16:27:57: SetupCompleteError.
Internal Error 2898. Tahoma8, Tahoma, 0
Internal Error 2898. TahomaBold10, Tahoma, 0
Action 16:27:58: SetupCompleteError. Dialog created
Action ended 16:28:02: SetupCompleteError. Return value 2.
Action ended 16:28:02: INSTALL. Return value 3.
...

I think what's in bold is causing the problem...

UltraGenda

UltraGenda