Bug #6200 ODBC Driver attempts netbios connection

• Submitted: 21 Oct 2004 18:09
• Modified: 23 Oct 2004 18:46
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S1 (Critical)
• Version: 3.51.09
• OS: Windows (Windows server 2003)
• CPU Architecture: Any

[21 Oct 2004 18:09] [ name withheld ]

Description:
I'd like to start by saying that version 3.51.06 does NOT have this problem.  I am connecting to a Linux based MySQL server from an ASP page running on Windows Server 2003.  The connection to the MySQL server seems to take forever, upon checking netstat, I noticed that the ODBC driver is trying to establish a netbios connection to the Linux box, and that is what is causing the delay.  It is trying port 445, if "Client for Microsoft Networks" is enabled, and it seems to try netbios no matter what (I tried disabling "netbios over tcp/ip" and saw no effect). Could this be related to the option that is available in the ODBC driver to connect to a Windows based MySQL server running named pipes?  Did this option get enabled by default?

How to repeat:
Connect using ODBC to a non-windows MySQL server from a Windows computer (see above).

[22 Oct 2004 18:00] MySQL Verification Team

I tested this issue on W3k,W2k and XP against a Slackware box without
to repeat the behavior.

[22 Oct 2004 21:36] [ name withheld ]

Can you verify that the slackware box you tested with was not running any netbios services such as samba?  I am making the connection from an ASP page, the connection commands I am using are:

Set Conn = Server.CreateObject("ADODB.Connection")
Set rss = Server.CreateObject("ADODB.Recordset")
Conn.CursorLocation=3
Conn.commandtimeout=60
Conn.Open "Driver={MySQL};DATABASE=rates;Server=mysql.dasyp.com;OPTION=16386", "username", "password"

username and password above are obviously dummy entries.  The ADO version running on the machine is 2.8, that is the defult install version.

[23 Oct 2004 18:46] MySQL Verification Team

Hi,
Indeed I run samba on my Slackware box and for to test again I
stopped the Samba stuff and tried from another computer Win98
(my son's computer) that never connected with Slackware box
and also I wasn't able for to repeat.
The anothers machines W3k, W2k and XP I assume that even 
stopping Samba the name resolution is already cached by Windows.

[25 Oct 2004 13:50] [ name withheld ]

I can't think of anything else to add, how did you try to create the connection from the windows machine to the slackware machine?  Did you try to make a query after the connection?

[27 Oct 2004 18:05] [ name withheld ]

Did you try any of the recommendations in the previous comment?