Skip to Content.
Sympa Menu

freetds - Re: [freetds] Regarding MSSQL connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Regarding MSSQL connection
  • Date: Wed, 25 Feb 2009 23:56:37 -0700

I don;t think I am using UnixODBC. I am using FreeTDS 0.82 and SQL Server
2003.

On Wed, Feb 25, 2009 at 11:52 PM, Gopalakrishnan A.N <saigop AT gmail.com>wrote:

> Hi Robert,
> Can you please let me know what version of UnixODBC, FreeTDS and SQL
> server you are using. I am using UnixODBC 2.2.12 ,FreeTDS 0.82 and SQL
> server 2000 enterprise edition.
>
> On Thu, Feb 26, 2009 at 12:06 PM, Robert Gonzalez <
> robert AT robert-gonzalez.com> wrote:
>
> > 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 <saigop AT gmail.com
> > >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 <
> > > robert AT robert-gonzalez.com> 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 <
> saigop AT gmail.com
> > > > >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 <
> > 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
> > > > _______________________________________________
> > > > 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
> > _______________________________________________
> > 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




Archive powered by MHonArc 2.6.24.

Top of Page