Bug #36356 Cannot set PIPE = -1 in connection staring
Submitted: 27 Apr 2008 0:33 Modified: 16 May 2008 10:40
Reporter: Anson Chapman Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:Connector/Net 5.0.51 OS:Any
Assigned to: CPU Architecture:Any
Tags: PIPE. Connectot

[27 Apr 2008 0:33] Anson Chapman
Description:
Cannot set PORT parameter to -1 in connection string to specify that i will "USE" named pipe for connection.

Error states that that the value in stringbuilder will not except an unsigned integer. Documentation says i should do that. 

By specifing PIPE and PROTOCOL i can work around error

Visual Basic 2008

    With MySQLConnStringBuilder
        .Add("Persist Security Info", False)
        .Add("Database", sDB)
        .Add("Data Source", gGeneral.DataSource)
        .Add("User Id", gGeneral.UserID)
        .Add("Password", gGeneral.Pass)
        If gGeneral.Protocol = "Named Pipes" Then
          .Add("Protocol", "NamedPipe")
          .Add("Pipe", "mysql")
          '                  .Add("Port", "-1")
          ' This causes error when line is uncommented 
        Else
          .Add("Port", gGeneral.Port.ToString())
        End If
    End With

How to repeat:
Repeat this using the vb code above and Visual Basic 2008

Suggested fix:
Allow signed integers
[28 Apr 2008 16:48] Reggie Burnett
This is verified as a documentation bug only.  Setting port to -1 for named pipe was old functionality.  Now you should set the protocol to pipe and set the pipe name property.
[28 Apr 2008 19:11] Reggie Burnett
Fixed in 5.1.6 and 5.2.2+ documentation (this is a docs only bug)
[16 May 2008 10:40] MC Brown
Documentation already updated.