I'm attempting to migrate my service mix-platform with mono, however in trying for connecting to some MS SQL database I recieve the next timeout error

Timeout expired. The timeout period passed just before the conclusion from the operation or even the server isn't reacting. at Mono.Data.Tds.Protocol.TdsComm..ctor


  at System.Data.SqlClient.SqlConnection.Open()

Databases are a newcomer in my experience, but so far as I will tell from here (google cache page, mono website is lower) being able to access MS SQL databases has become possible is Mono. Is the fact that correct?

Cleaning it once a to structure my connection string as proven, but nonetheless no luck. My simple test code...

using (SqlConnection con = new SqlConnection(cs))

            {

                con.Open();

                SqlDataReader reader = null;

                SqlCommand cmd = new SqlCommand("SELECT Parameter FROM Deltas", con);

                reader = cmd.ExecuteReader();

                reader.Read();

                    Console.WriteLine(reader["Parameter"].ToString());

                con.Close();

            }

Shall We Be Held missing any references or perhaps is my format incorrect? How do i connect using Mono C#?

EDIT:

Connection String, Defined globally and init in constuctor:

         cs = @"Server=xxx.xxx.xxx.xxx;
               Database=myDB;
               User ID=user;
               Password=passwd;";


     cs = @"Data Source=xxx.xxx.xxx.xxx;
               Network Library=DBMSSOCN;
               Initial Catalog=myDB;
               User ID=user;
               Password=passwd;";

Top is me attempting to comply with the mono example, bottom is exactly what works together with the .Internet runtime.

It appears you hit a bug:

http://www.mail-archive.com/mono-bugs@lists.ximian.com/msg50686.html

quote:

This only happens while using the .Internet 2. version of TdsComm - when producing with .Internet 1. (mcs rather than gmcs), the bond also works.