[freetds] Regarding MSSQL connection
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
> -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
> > Gopalakrishnan A.N wrote:
> > > I am trying to connect MS SQL server, but it gets fails with SQL
> > > 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,
> PeopleTech Systems Private Limited
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS