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 13:34:58 +0530

Hi Robert,
Thru this command I can able to see the 1> prompt,

[root@localhost ~]# tsql -S egServer70 -U cims
locale is "C"
locale charset is "ANSI_X3.4-1968"
Password:
1> help;
2> ?
3>
4>
5>
6>
7>
8>
9> use database cims;
10> select * from DLR_DIAL_DTC;
11> select * from DLR_DIAL_DTC
12>
13>
14> QUIT
[root@localhost ~]# TDSVER=7.0 tsql -H 172.20.182.10 -p 1433 -U cims
locale is "C"
locale charset is "ANSI_X3.4-1968"
Password:
1> use database cims;
2> select * from DLR_DIAL_DTC;
3>
4> quit

Is it correct? but I cant able to see any ouput of this command.

On Thu, Feb 26, 2009 at 1:21 PM, Gopalakrishnan A.N <saigop AT gmail.com>wrote:

> Hi Robert,
> For me the output of the command tsql -C and I have commented in bold,
> please assist me to go ahead.... Thanks in advance.
>
> [root@localhost ~]# tsql -C
> Compile-time settings (established with the "configure" script)
> Version: freetds v0.82
> freetds.conf directory: /usr/local/etc
> MS db-lib source compatibility: no // here do i need this to yes to
> communicate with SQL server?
> Sybase binary compatibility: no
> Thread safety: yes
> iconv library: yes
> TDS version: 5.0 //here I am using v0.82 which is
> version 8 rite?
> iODBC: no
> unixodbc: yes //unixodbc is yes, is this
> creates problem?
>
>
> On Thu, Feb 26, 2009 at 12:56 PM, Robert Gonzalez <
> robert AT robert-gonzalez.com> wrote:
>
>> 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 <saigop AT gmail.com
>> >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 <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
>> > _______________________________________________
>> > 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