Skip to Content.
Sympa Menu

freetds - Re: [freetds] tsql msg error 20009

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tareq <tarek.atallah AT tahadi.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tsql msg error 20009
  • Date: Mon, 26 Oct 2009 13:13:41 +0200

Thanks it works fine now




Tarek Atallah
Senior Database Administrator
Tahadi Games - www.tahadi.com
Mobile +962 776555508
E-mail W : tarek.atallah AT tahadi.com
E-mail P : tarek.atallah AT gmail.com


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: Sunday, October 25, 2009 10:38 AM
To: FreeTDS Development Group
Subject: Re: [freetds] tsql msg error 20009

Use -H instead of -S

bye
freddy77

Il giorno 25/ott/2009, alle ore 09.57, Tareq
<tarek.atallah AT tahadi.com> ha scritto:

> Hi very one,
>
> I have installed tds , now I want to check the connection with sql
> I tried tsql -S 'myip' -p 'myport' -U 'myuser' -P 'mypassword'
>
> I keep getting this error
>
> Msg 20009, Level 9, State -1, Server OpenClient, Line -1
> Unable to connect: Adaptive Server is unavailable or does not exist
> There was a problem connecting to the server
>
> Any help?
>
>
>
>
> Tarek Atallah
> Senior Database Administrator
> Tahadi Games - www.tahadi.com
> Mobile +962 776555508
> E-mail W : tarek.atallah AT tahadi.com
> E-mail P : tarek.atallah AT gmail.com
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> jklowden AT schemamania.org
> Sent: Friday, October 23, 2009 8:53 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Ms sql backslash in named instance 2005
>
> On Fri, Oct 23, 2009 at 06:56:00PM +0100, apk AT blueyonder.co.uk wrote:
>> thanks freedy and cedric for your quick response. Although that
>> works, I'm
> in a difficult situation where I need it to work as before. I won't
> go into
> all the details but I have an existing app that not only uses
> freetds as its
> intended but also parses it and uses it within an application. I
> can't alter
> the app and need the functionality we have been using up to now.
>> Do you know if the problem I have is a bug or a feature?
>
> Maybe a little of both. I would say it's undesirable.
>
> What's happening: tds_read_config_info() calls
> parse_server_name_for_port()
> whose real purpose is to interpret instance\hostname and hostname:port
> strings.
> It's not supposed to interpret the [servername] string in
> freetds.conf,
> but that's what it's doing.
>
> If you set TDSDUMPCONFIG, you'll see near the top of the log it's
> looking
> for
> your 'server\name' name, and then another message, "Parsed
> servername, now
> back on 0" that means it parsed for a port number and came up with
> zero.
>
> I think the idea, once upon a time, was that
>
> tsql -S 'instance\servername'
> or
> tsql -S 'servername:port'
>
> would be a way to override the instance/port in freetds.conf. But
> I'm not
> so
> sure that's such a great feature and, even if it is, it belongs
> properly to
> the tsql application, not libtds.
>
> I would try deleting the call to parse_server_name_for_port() and
> see if
> that solves your problem.
>
> HTH.
>
> --jkl
>
>
>>
>> -----Original Message-----
>>
>> From: Frediano Ziglio <freddy77 AT gmail.com>
>> Date: Fri 23 Oct 2009 18:08
>>
>> Il giorno ven, 23/10/2009 alle 17.46 +0100, apk AT blueyonder.co.uk ha
>> scritto:
>>> Hi,
>>> using freetds version 0.82 on solaris 10. tsql fails to connect to
>>> sql
> server named instances as they contain backslashes. Ie.
>>> tsql -S'hostname\instancename' -U joe -P bloggs
>>> A work around is to remove the backslash in freetds.conf. However,
>>> this
> worked fine in freetds 0.62.4.
>>>
>>> The only error is
>>> 'There was a problem connecting to the server'.
>>>
>>> Its quite important that we maintain the exisiting functionality.
>>>
>>> Has anyone else seen this and is there a solution that would avoid
>>> using
> an unstable version?
>>>
>>>
>>
>> Try -H instead of -S
>>
>> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page