BUG: SQLOLE_STARTSRV_TYPE Datatypes Fail When Using StartMode

ID: Q159846

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 16257 (sqlbug_65 sql 6.5)

SYMPTOMS

When you issue the Start Method, all SQLOLE_STARTSRV_TYPE datatype parameters except for SQLOLEStart_Defaults and SQLOLEStart_StartAndConnect will fail their desired behavior.

WORKAROUND

To work around this problem, do one of the following:

For SQLOLE_NoServiceControl, spawn a new Sqlservr.exe process, using the -c command line parameter.

For SQLOLE_NTErrorLogging, spawn a new Sqlservr.exe process, avoiding the -n command line parameter.

For SQLOLE_SingleUser, spawn a new Sqlservr.exe process, using the -m command line parameter.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce the Problem:

Create a VB Project with a single command button on a form.

Insert the following code:


   Private Sub Command1_Click()
       Dim SQLServer As New SQLServer

       SQLServer.Start "VOOM", "sa", "", , , , SQLOLEStart_SingleUser

   End Sub

   This will start SQL Server, but not in single user mode.

Open ISQL/w and create as many connections as you want.

Additional query words: DMO distributed management objects


Keywords          : kbusage SSrvDMO SSrvISQL kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999