[Mono-list] SQL Server 2005 Support

[Austin Winstanley]

try port 1226



On Dec 16, 2007 4:33 PM, Konstantin Bokarius <bokarius at comcast.net> wrote:

>  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.152MS SQL 2005 do I see the error.
>
>
>
> *From:* Nagappan A [mailto:nagappan at gmail.com]
> *Sent:* Saturday, December 15, 2007 8:45 PM
> *To:* Konstantin Bokarius
> *Cc:* Austin Winstanley; Mono-list at lists.ximian.com
> *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 at comcast.net>
> 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 at gmail.com [mailto:austinwinstanley at gmail.com] *On
> Behalf Of *Austin Winstanley
> *Sent:* Saturday, December 15, 2007 3:15 PM
> *To:* Konstantin Bokarius
> *Cc:* Nagappan A; Mono-list at lists.ximian.com
>
>
> *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 at comcast.net>
> 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 at gmail.com]
> *Sent:* Friday, December 14, 2007 9:09 AM
> *To:* Veerapuram Varadhan
> *Cc:* bokarius at comcast.net; Mono-list at lists.ximian.com
> *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 at novell.com>
> 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 at novell.com>
>
> _______________________________________________
> Mono-list maillist  -   Mono-list at lists.ximian.com
> 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 at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
> --
> Linux Desktop Testing Project - http://ldtp.freedesktop.org
> http://nagappanal.blogspot.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20071216/ee7468fb/attachment.html