Skip to Content.
Sympa Menu

freetds - Re: [freetds] Regarding MSSQL connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Regarding MSSQL connection
  • Date: Wed, 25 Feb 2009 23:00:41 -0700

Do you have the FREETDSCONF environment variable set? I ran into this a few
weeks ago and after adding a FREETDSCONF=/etc/freetds/freetds.conf variable
it began to work.

On Wed, Feb 25, 2009 at 10:53 PM, Gopalakrishnan A.N <saigop AT gmail.com>wrote:

> Hi James,
> Again I am getting like this error when I try to use
>
> [root@localhost ~]# tsql -S 172.20.182.10 -p 1433 -U cims -P
> $ql$wtcintra08
> -D cims
> locale is "C"
> locale charset is "ANSI_X3.4-1968"
> 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
> [root@localhost ~]#
>
> what could be the reason? I have changed the servername too.
>
> On Mon, Feb 23, 2009 at 6:27 PM, James K. Lowden <jklowden AT freetds.org
> >wrote:
>
> > Gopalakrishnan A.N wrote:
> > > I am trying to connect MS SQL server, but it gets fails with SQL
> connect
> > > error. ... I am attaching my
> > > freetds.conf, odbc.ini and odbcinst.ini
> >
> > > Servername = 172.20.182.10
> >
> > should be
> >
> > Servername = egServer70
> >
> > The ODBC Servername connection property refers to a name in freetds.conf.
> >
> >
> > (The osql script is intended to report mistakes like this.)
> >
> > HTH.
> >
> > --jkl
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
>
> --
> Thank you with regards,
> Gopal,
> PeopleTech Systems Private Limited
> www.peopletech.co.in
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--

Robert Gonzalez
http://www.robert-gonzalez.com




Archive powered by MHonArc 2.6.24.

Top of Page