BUG: SQLOLE_STARTSRV_TYPE Datatypes Fail When Using StartMode (159846)

The information in this article applies to:

Microsoft SQL Server 6.5

This article was previously published under Q159846

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.

Modification Type:	Major	Last Reviewed:	10/3/2003
Keywords:	kbBug kbusage KB159846