[Mono-list] SQLClient problems

[Veerapuram Varadhan]

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