BUG: SQLOLE_STARTSRV_TYPE Datatypes Fail When Using StartMode

• Microsoft SQL Server, version 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:

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

2. 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.
   
   

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