Re: SQL Server 2005 Support

The service is running and it is not protected by a firewall as I can telnet to port 1433 on 10.10.1.152 from the system running Mono.

 

When I change the connect string to connect to 10.10.1.150 running an older version of MS SQL it works fine, only when I point it to 10.10.1.152 MS SQL 2005 do I see the error.

 

From: Nagappan A [mailto:nagappan@...]
Sent: Saturday, December 15, 2007 8:45 PM
To: Konstantin Bokarius
Cc: Austin Winstanley; Mono-list@...
Subject: Re: [Mono-list] SQL Server 2005 Support

 

Hi,

It looks like either the service is not running in the default port or its protected with firewall.

Thanks
Nagappan

On Dec 15, 2007 5:37 PM, Konstantin Bokarius <bokarius@...> wrote:

Here is my code:

        private static string strConnect = "Server=10.10.1.152;" +
                                              "Database=TESTDB;" +
                                              "User ID=userid;" +
                                              "Password=pwd;";
        private static SqlConnection dbCon;
        private static IDbCommand dbCmd;
        private static IDataReader dbReader;

        ...

        dbCon = new SqlConnection(strConnect);
        dbCon.Open();

Here is the error I get:

Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException: Server does not exist or connection refused. ---> System.Net.Sockets.SocketException: Connection refused
  at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end) [0x00000]
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End of inner exception stack trace ---


I have tried specifying the port (1433) and using Net=dbmssocn; and I still get the same error.

From: austinwinstanley@... [mailto:austinwinstanley@...] On Behalf Of Austin Winstanley
Sent: Saturday, December 15, 2007 3:15 PM
To: Konstantin Bokarius
Cc: Nagappan A; Mono-list@...

Subject: Re: [Mono-list] SQL Server 2005 Support

 

What does your connection string look like? I had to use the port number to connect. My connection string looks like this:

Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User ID=[myusername];Password=[mypassword];

where the x's are my ip address and 1226 is the port

On Dec 15, 2007 5:04 PM, Konstantin Bokarius <bokarius@...> wrote:

I can't seem to get Mono connected to MS-SQL2005.  What Mono SQL Client should I be using?

 

From: Nagappan A [mailto:nagappan@...]
Sent: Friday, December 14, 2007 9:09 AM
To: Veerapuram Varadhan
Cc: bokarius@...; Mono-list@...
Subject: Re: [Mono-list] SQL Server 2005 Support

 

Hi,

MS-SQL 2005 works fine under Mono. But the additional features like SqlNotification won't work.

Thanks
Nagappan

On Dec 14, 2007 3:29 AM, Veerapuram Varadhan <vvaradhan@...> wrote:

Hi Bokarius,

On Fri, 2007-12-14 at 02:52 -0800, Konstantin Bokarius wrote:
> Does Mono have SQL Server 2005 support yet?  Which SQL Client
> available today would be the best bet?
>

SQLServer 2005 is yet to be supported in Mono and all prior versions are
very much supported.

V. Varadhan


--
Veerapuram Varadhan <vvaradhan@...>

_______________________________________________
Mono-list maillist  -   Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

 

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com