Re: Regarding MSSQL connection

Sorry, I should have said this before... what is the path to your
freetds.conf? On Fedora/RedHat linux it is usually /etc/freetds.conf and on
Ubuntu/Debian it is /etc/freetds/freetds.conf

Of course these paths could be based on FreeTDS versions, but I just know
what I went through recently. I got the exact same error you got and fixed
it by exporting FREETDSCONF equal to the path to the FreeTDS conf file.

Also make sure your freetds conf file is set up properly. No matter how hard
I tried to connect by host name and port i was never able to do that on both
Fedora and Ubuntu. It was only after I made an entry in the freetds.conf and
tried to connect with the servername alias that it would connect.

Here are a few links for what I have done to make it work on both Ubuntu and
Fedora:
http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/
http://www.robert-gonzalez.com/2008/03/31/connecting-php-on-linux-to-mssql-on-windows/

Both of those are specifically geared toward getting PHP to talk to SQL
Server using its own extension. However in order to do that you have to be
able to use tsql at the command line. In both cases I was able to get tsql
to connect.

HTH, this is not really a strong suit of mine but I know it is very
frustrating when it doesn't work like you expect it to. ;)

On Wed, Feb 25, 2009 at 11:26 PM, Gopalakrishnan A.N <[email protected]>wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

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