Re: Regarding MSSQL connection

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 <[email protected]>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 <[email protected]
> >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
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
>
> --
> Thank you  with regards,
> Gopal,
> PeopleTech Systems Private Limited
> www.peopletech.co.in
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

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