[Mono-list] FW: SQL Server 2005 Support

Sun Dec 16 23:06:14 EST 2007

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
<mailto: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.152 MS 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
<mailto: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
<mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20071216/78432dec/attachment-0001.html 