Re: Regarding MSSQL connection

Hi Robert,
 Thanks for your suggestion. I tried like this to set the environment
variable export FREETDSCONF=/usr/local/freetds-0.82/freetds.conf:$PATH

and tried to connect with tsql
[root@localhost freetds-0.82]# tsql -H 172.20.182.10 -p 1433 -U cims -P
$ql$wtcintra08 -D cims
locale is "C"
locale charset is "ANSI_X3.4-1968"
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server
[root@localhost freetds-0.82]#

I faced the adaptive server connection. How to go ahead from this stage?
please assist me. thanks in advance

On Thu, Feb 26, 2009 at 11:30 AM, Robert Gonzalez <
[email protected]> wrote:

> 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
> _______________________________________________
> 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