[Mono-osx] [Mono-list] Mono WinForms Problems Connecting to Sql 2005

[Daniel Morgan]

How does you connection string look like?

You can rename your actual user id and password to
xxxx.

Are you using an instance name in your connection
string?  You mentioned you are connecting via SQL
Server Authentication.  

Have you increased the CONNECTION TIMEOUT?  The
default is 15 seconds.

To know for sure you're connecting via .net the same
way you are in mono, add this to your connection
string for running on .net:

;network library=dbmssocn

Then if you get the same thing on .net as you do with
mono, then you know its something with connecting via
TCP/IP.  And if you were using a named instance, then
you may need to open up access to UDP port 1434.

Here is an entry from my blog about this.

http://www.mfconsulting.com/danmorg/blog/archives/000145.html

Here is the msdn doc on SqlConnection.ConnectionString

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx


--- Austin Winstanley <austin at tradelogic.com> wrote:

> I am running a Mono Winforms app and i have gotten
> it to run great on
> Windows, Linux, and Mac OSX. The problem is I can
> only connect to a
> Sql Server 2005 DB from Windows. It is a remote DB
> and it connects
> just fine when I am in Windows, but as soon as I run
> my app from Mac
> or Linux, It gives me Sql Server does not exist or
> connection denied
> error. I'm not understanding why it will connect
> from Windows but not
> Mac or Linux. Any help would be great. Thanks!
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 



 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265