Re: Regarding MSSQL connection

"Gopalakrishnan A.N" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
Hi Robert,
  This is the command for freetds ./configure –with-tdsver=8.0
–with-unixODBC=/usr/local

1. I am creating the odbcinst.ini it contains the defnition of ODBC driver
2. I am creating odbc.ini this contains the MSSQL information with DSN name
3. For testing I tried isql -v <DSN name> <database_username>
<database_password>
4. In javascript I am using the DSN name to connect with the MSSQL server


On Thu, Feb 26, 2009 at 10:55 PM, Robert Gonzalez <
[email protected]> wrote:

> What was your configure command when you built freetds? How are you
> attempting to connect to SQL Server with Javascript?
>
> On Thu, Feb 26, 2009 at 2:50 AM, Gopalakrishnan A.N <[email protected]
> >wrote:
>
> > 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
> > _______________________________________________
> > 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
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.