Re: latest FreeTDS on Centos 6.4 and latest SQL Server DB

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

> 2014-08-17 22:06 GMT+02:00 Nunzio Luigi Puleio <[email protected]>:
>
> > 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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>