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: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Regarding MSSQL connection
  • Date: Thu, 26 Feb 2009 23:01:21 -0700

Have you tried what I did in this article to connect to SQL Server from
Ubuntu<http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/>
?

I believe I used ./configure --prefix=/usr/local/freetds --enable-msdblib


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

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




Archive powered by MHonArc 2.6.24.

Top of Page