SQL-DMO SQLServer.Start and Instances problem -- sql server connect

Paul Buxton
9/23/2003 5:38:00 PM

Hi all,

I have a SQLServer or MSDE Instance called X, which I am trying to start
through SQL-DMO.

I've noticed a difference between the OS's

Using the following......

set o=CreateObject("SQLDMO.SQLServer")
o.Start 0, "(local)\X"

This only works on Win98/ME machines!

To start an instance on 2000/NT/XP, I need to do it as

o.Start 0, ".\X"

Am I missing something very very obvious? I was understanding the (local)
was universal over the OS's from 98 upwards.

Thx,

Gert E.R. Drapers
9/26/2003 1:08:45 PM

Look at the Service example that ship with SQL Server
C:\Program Files\Microsoft SQL
Server\80\Tools\DevTools\Samples\sqldmo\vb\Service

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.

[quoted text, click to view]

sql server connect : SQL-DMO SQLServer.Start and Instances problem