Skip to Content.
Sympa Menu

freetds - Re: [freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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
>




Archive powered by MHonArc 2.6.24.

Top of Page