freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB
- From: Nunzio Luigi Puleio <npuleio AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB
- Date: Mon, 18 Aug 2014 12:09:37 +0200
Hello Frediano,
thanks for your answer.
Well, first I have Centos 6.4 Final x86_64, Freetds x86_64 installed
version 0.91-2.el6, unixODBC 2.2.14-12.el6_3, php 5.3.3 and settled for my
purpose:
in freetds.conf
[global]
tds version = 9.0
[MSSQLDBGateway]
host = X.X.X.X
port = 1433
tds version = 9.0
and in odbc.ini
[MSSQLDBGateway]
Driver = FreeTDS
#Server = X.X.X.X
Servername = MSSQLDBGateway
Port = 1433
Database = xxxx
TDS_Version = 9.0
and in odbcinst.ini this:
[FreeTDS]
Description = ODBC for SQL Server
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsS.so.0
UsageCount = 1
FileUsage = 1
when I settled tds version 7.2 or 8.0, performance with SQL Server 2008
communication was poor then I tried to set 9.0 as it said here:
TDS 7.2 Microsoft, *was* 9.0
Introduced for SQL Server 2005. Includes support for varchar(max),
varbinary(max), xml datatypes and MARS.
then it improved a bit.
Maybe I missed something?
Thanks
Cheers
Luigi
On Mon, Aug 18, 2014 at 9:39 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 2014-08-17 22:06 GMT+02:00 Nunzio Luigi Puleio <npuleio AT gmail.com>:
>
> > Hello everyone!
> >
> > I have CentOS 6.4 64bit webserver and a SQL Server 2008 DB.
> > I communicate with SQL Server with unixODBC but looks like it's not
> really
> > performant.
> > So I tried to set in odbc.ini TDS_Version = 9.0 and it started to be a
> bit
> > more performant.
> >
>
> 9.0 ?? See http://www.freetds.org/userguide/choosingtdsprotocol.htm, you
> are using really old documentation.
> Performant doing what? Do you have many connection? Usually is the problem
> of web servers. Many web servers have support for connection caching. See
> unixODBC documentation too.
>
>
> > BUT since doing tsql -C I see TDS Version as 4.2 so I guess it isn't
> really
> > performant so I am here asking you if to be more performant shall I have
> to
> > do makefile with latest freetds sources with patrameter --with-tdsver=
> > *VER *settled as 7.2 ?
> >
> >
> There are many way to override default protocol version. For ODBC you can
> use connection string, if you are using a DSN configuration set the right
> attribute.
>
>
> > Thanks in advance.
> > Cheers,
> > Luigi
> >
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
-
[freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
Nunzio Luigi Puleio, 08/17/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
Frediano Ziglio, 08/18/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
Nunzio Luigi Puleio, 08/18/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
James K. Lowden, 08/19/2014
- Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB, Nunzio Luigi Puleio, 08/19/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
James K. Lowden, 08/19/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
Nunzio Luigi Puleio, 08/18/2014
-
Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB,
Frediano Ziglio, 08/18/2014
Archive powered by MHonArc 2.6.24.