[Mono-list] SQLClient problems

[Veerapuram Varadhan]

On Fri, 2009-02-27 at 08:11 +0100, laas wrote:
> I have set the port to 1433; the server name in the connection string
>  is "SERVER\INSTANCE" and there is only one SQL Server instance on the
> machine.
> 
> 
> The message is not changed.
> 

As Gonzalo pointed out, trunk and 2.4 has quite a lot of SqlClient
improvements and fixes.  One option would be to upgrade to either of
these versions or send me a .pcap (wireshark - mask your server name/ip
address) that captures your unsuccessful connection attempt to the
server.

V. Varadhan

> 
> LAAS
> 
> On Fri, Feb 27, 2009 at 5:31 AM, Veerapuram Varadhan
> <vvaradhan at novell.com> wrote:
>         On Thu, 2009-02-26 at 13:25 +0100, laas wrote:
>         > SQL Server is working fine. I have another web application
>         running on
>         > IIS that uses the same database constantly with no errors.
>         The problem
>         > arise with mono running the sample code on my Debian
>         machine.
>         > And, again, the strange thing is that one or two times it
>         works fine,
>         > in the next connection the message is always the same "SQL
>         Server does
>         > not exist or access denied".
>         >
>         
>         What is "Data Source/Server" field in your connection string
>         set to - IP
>         of the box running SQL Server or DNS resolvable name?
>         
>         If you are using IP address, it may fail for certain cases
>         whenever the
>         reverse lookup for the host name fails.
>         
>         Have a look at
>         https://bugzilla.novell.com/show_bug.cgi?id=407208 -
>         fixed after 1.9.x.
>         
>         I am not sure whether SQL 2005 Express has dynamic port
>         support, if so,
>         please choose the default port by disabling dynamic port.
>         
>         HTH,
>         
>         V. Varadhan
>         
>         
>         >
>         > Regards
>         > LAAS
>         >
>         > On Thu, Feb 26, 2009 at 1:16 PM, Petit Eric
>         <surfzoid at gmail.com>
>         > wrote:
>         >         2009/2/26 laas <laas.mono at gmail.com>:
>         >         > Hi all,
>         >         > reading and using the sample code in the following
>         page:
>         >         > http://www.mono-project.com/SQLClient#Testing
>         >         >
>         >         > every time i connect to the remote SQL Server
>         instance I
>         >         receive the
>         >         > following:
>         >         > "SQL Server does not exist or access denied"
>         >         > The strange thing is that sometimes the same
>         executable file
>         >         works fine
>         >         > (with no re-compilation).
>         >         > The used SQL Server (sql server express 2005)
>         allows remote
>         >         connections and
>         >         > has TCP/IP protocol turned on. I'm using the code
>         referred
>         >         to the topic "C#
>         >         > Example using SQL Server Authentication";
>         >         > Some idea ?
>         >
>         >         You don't have network trouble or SQL server "crash"
>         and
>         >         restart ?
>         >         > Many thanks in advance
>         >         > --
>         >         > [LAAS]
>         >         > WebSite: http://www.laas02.org
>         >         > YTSite: http://www.laas02.org/?page_id=17
>         >         >
>         >
>         >         > _______________________________________________
>         >         > Mono-list maillist  -  Mono-list at lists.ximian.com
>         >         > http://lists.ximian.com/mailman/listinfo/mono-list
>         >         >
>         >         >
>         >
>         >
>         >
>         >         --
>         >
>         >         Cordially.
>         >
>         >         Small Eric Quotations of the days:
>         >
>         ---------------------------------------------------------------------------
>         >         If one day one reproaches you that your work is not
>         a work of
>         >         professional, say you that:
>         >         Amateurs built the arch of Noah, and professionals
>         the
>         >         Titanic.
>         >
>         ---------------------------------------------------------------------------
>         >
>         >         Few people are done for independence, it is the
>         privilege of
>         >         the powerful ones.
>         >
>         ---------------------------------------------------------------------------
>         >
>         >         No key was wounded during the drafting of this
>         message.
>         >
>         >
>         >
>         > --
>         > [LAAS]
>         > WebSite: http://www.laas02.org
>         > YTSite: http://www.laas02.org/?page_id=17
>         >
>         > _______________________________________________
>         > Mono-list maillist  -  Mono-list at lists.ximian.com
>         > http://lists.ximian.com/mailman/listinfo/mono-list
>         
>         
> 
> 
> 
> -- 
> [LAAS]
> WebSite: http://www.laas02.org
> YTSite: http://www.laas02.org/?page_id=17