Hello,
I'm having a problem trying to create an upgrade for an application. The program is written in VB6 and uses MSDE 2000 (SQL Server 2000). MSDE was installed with the original application as a package from Microsoft. Additional DLL's were distributed using Installshield (kicks off MSDE setup before installing additional DLL's). After comparing the version 1 and 2 setups I have only added mswinsck.ocx and ntwdblib.dll (MSDE network library). I created a separate VB exe to copy in the new Program.EXE and update the tables with structure changes. Everything works except automatically starting the server. The error occurs when calling the Start method of a SQLDMO.SQLServer2 object. The odd thing is that I can instantiate the object (early or late binding) and can call other methods. This tells me that it is a dependant DLL. I also found that if I use "(local)" instead of "127.0.0.1" it will work and start SQL Server. My guess is that "(local)" may be using named pipes as opposed to "127.0.0.1" using TCP/IP causing a different DLL to be used by SQLDMO.DLL.
How do I track down the DLL that is either not registered or the wrong version since I'm not calling the dependant DLL directly?

Thanks,

John Davidson