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: "Gopalakrishnan A.N" <saigop AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Regarding MSSQL connection
  • Date: Thu, 26 Feb 2009 12:54:30 +0530

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 <saigop AT gmail.com>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 <
> robert AT robert-gonzalez.com> 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 <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
>> _______________________________________________
>> 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
>



--
Thank you with regards,
Gopal,
PeopleTech Systems Private Limited
www.peopletech.co.in




Archive powered by MHonArc 2.6.24.

Top of Page