I am building a VB application using MSDE as an engine. Originally this application was built using MSDE 1.0 (SQL 7.0). I found examples of how to start MSDE if it wasn't already started.
Now I have moved to MSDE2000. The same code that started MSDE 1.0 now does not work. It gives an error [SQL-DMO]Service Control Error: The specified service does not exist as an installed service.
Server name is (local) since the application is a workstation based application.
If I use the sample code from:
c:\program files\microsoft SQL server\80\tools\devtools\s
I get the same error.
This is really upsetting because I lost a huge sale last December because I couldn't find an answer to this message doing a demo at a client site on a client PC running Windows 2000.
Why provide an example of how to start the service if the example does not work!
Basically I need to make sure MSDE is started on the workstation, check to see if a database exists, if not, attach the database, set defaults in tables etc.
Apps Done Rite
"Building the next steps"