[Mono-bugs] [Bug 372932] Connection to Microsoft SQL Server Failed

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=372932

User vvaradhan at novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=372932#c1


Veerapuram Varadhan <vvaradhan at novell.com> changed:

           What    |Removed                                         |Added
----------------------------------------------------------------------------
                 CC|                                                |vvaradhan at novell.com
             Status|NEW                                             |NEEDINFO
      Info Provider|                                                |avk at rsdn.ru




--- Comment #1 from Veerapuram Varadhan <vvaradhan at novell.com>  2008-04-22 07:13:18 MST ---
I tried the same example, with slightly modified connection string:

static void Main()
{
        const string connStr =
                        @"User
ID=monotester;Pwd=*******;Server=127.0.0.1;Integrated
Security=no;Initial Catalog=monotest";
        const string cmdText = "SELECT COUNT(*) FROM tmp_table";
        for (var i = 0; i < 3; i++)
                using (var con = new SqlConnection(connStr))
                using (var cmd = new SqlCommand(cmdText, con))
                {
                        con.Open();
                        Console.WriteLine("{0} : {1}", i, cmd.ExecuteScalar());
                }
}

And got:

0 : 2
1 : 2
2 : 2

as I had two rows on the tmp_table.  I tested this with both 1.9 branch and
trunk.

My MS SQL Server Management Studio Express reported the following version
information:

Microsoft SQL Server Management Studio Express                                 
        9.00.2047.00

Microsoft Data Access Components (MDAC)                                        
2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML                                         2.6 3.0 4.0 6.0 

Microsoft Internet Explorer                                            
7.0.5730.11

Microsoft .NET Framework                                               
2.0.50727.1433

Operating System                                                5.1.2600


Which version of Mono did you try with?


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.