Microsoft KB Archive/159846

= BUG: SQLOLE_STARTSRV_TYPE Datatypes Fail When Using StartMode =

Article ID: 159846

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Additional query words: DMO distributed management objects

Keywords: kbbug kbusage KB159846

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.