[Mono-list] FW: SQL Server 2005 Support
Nagappan A
nagappan at gmail.com
Mon Dec 17 00:16:14 EST 2007
Hi,
To diagnose the issue, probably you can connect to the same server using
Windows .NET and run the same test program without any changes should give
you some hint. I guess.
Thanks
Nagappan
On Dec 16, 2007 8:06 PM, Konstantin Bokarius <bokarius at comcast.net> wrote:
> I can telnet to port 1433 and when I do a port scan I can see port 1433
> open for SQL Server. I can use SQL Server Management Studio to connect to
> the MS SQL Server 2005 system using default settings. I tried a couple
> different forms of connections strings in Mono that work on an older MS SQL
> Server system none of which worked on MS SQL Server 2005. When I try
> connecting with Mono I get the 'Server does not exist or connection
> refused' error. Not sure what to try at this point.
>
>
>
> *From:* Dale Moore [mailto:daleemoore at gmail.com]
> *Sent:* Sunday, December 16, 2007 2:55 PM
>
> *To:* Konstantin Bokarius
> *Cc:* Nagappan A; Mono-list at lists.ximian.com
> *Subject:* Re: [Mono-list] SQL Server 2005 Support
>
>
>
> I recall one MS SQL 2005 I installed needed to be configured to allow
> remote connections.
>
> 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
>
>
> _______________________________________________
> 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/0e3f82c3/attachment.html
More information about the Mono-list
mailing list