Re: Regarding MSSQL connection

Try looking for .lib (notice the dot in front). That might be it.

For the record, I don't use UnixODBC. It is only freetds


On Thu, Feb 26, 2009 at 12:24 AM, Gopalakrishnan A.N <[email protected]>wrote:

> Hi Robert,
>  I am using Cent OS 5.2. I gone thru the link you have provided, I found a
> entry /usr/local/freetds/lib what I have downloaded is freetds stable
> release, inside that I cant able to find any lib folder. The older version
> also I cant able to find any one. Where to get the lib folder. And also
> please let me know while installing freetds we need to enable the msdblib.
>
> On Thu, Feb 26, 2009 at 12:47 PM, Gopalakrishnan A.N <[email protected]
> >wrote:
>
> > Hi Robert,
> >   Actually what is the difference between UnixODBC and FreeTDS. My
> concern
> > is I need to connect my linux machine with SQL server 2000. So I need to
> use
> > UnixODBC or FreeTDS? Please suggest me.
> >
> >
> > On Thu, Feb 26, 2009 at 12:26 PM, Robert Gonzalez <
> > [email protected]> wrote:
> >
> >> 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 <[email protected]
> >> >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 <
> >> > [email protected]> 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 <
> >> [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
> >> > > _______________________________________________
> >> > > 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
> >
>
>
>
> --
> 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