[freetds] Regarding MSSQL connection
Robert Gonzalez
robert at robert-gonzalez.com
Thu Feb 26 01:00:41 EST 2009
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 at 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 at 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
More information about the FreeTDS
mailing list