Re: Regarding MSSQL connection

"Gopalakrishnan A.N" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
Hi All,
   I am using Javascript to connect to MS SQL server. For this I am using
FreeTDS and UnixODBC, I am facing issue with isql saying that SQL connect
error. I have tried lot of combinations, some where I  am wrong. Robert also
suggested me some things but still not able to succeed.

  So someone can assist me how to go ahead.

On Thu, Feb 26, 2009 at 1:34 PM, Gopalakrishnan A.N <[email protected]>wrote:

> 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 <[email protected]>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 <
>> [email protected]> 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 <[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
>>> _______________________________________________
>>> 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
>



-- 
Thank you  with regards,
Gopal,
PeopleTech Systems Private Limited
www.peopletech.co.in
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.