Re: unixodbc: no ??

What we discovered was that unixODBC overwrites several SQL header files when you run 'make install'. Later on, you want to build another application, such as: freeTDS or OpenLDAP (which makes use of SQL header files), and then you get a lot of problems. I raised this issue several months ago but nothing has changed since then!

> To: [email protected]
> From: [email protected]
> Date: Wed, 12 Oct 2011 16:17:41 +0000
> Subject: Re: [freetds] unixodbc: no ??
> 
> > The packaging of unixODBC is very distribution specific.  Some (like
> > Gentoo) always install headers, some (like Redhat) separate the
> > packages in to the main unixODBC and unixODBC-devel.  
> 
> First all my thanks for your assistance - we're closing in, I had our Linux 
> Sysad letting me install under /usr/local on another machine and had good 
> results with this - details at the bottom..
> 
> > Distribution specific: 
> I've got only 1 download from unixODBC http://www.unixodbc.org/download.html. 
> It doesn't look from this page that I'd need to search for anything else. And 
> what would this download be here for otherwise.
> 
> Similarly, I've got only 1 download from freeTDS http://www.freetds.org/ 
> the 'Stable release' (not concerned of the nightly snapshot). This seems 
> straighforward.
> 
> In neither I see other options, or indications of specific distributions that I 
> should be aware of, so I'm clicking these 2 links in both products, unixODBC 
> first, and gunzip and tar -xvf, right?
> 
> > Suffice it to say, if you have sql.h, sqlext.h and friends, then you should 
> have all you need.
> 
> This is what is puzzling, I do have these like you can see:
> 
> [gnu@roman grenetie]$ pwd
> /home/grenetie
> [gnu@roman grenetie]$ find -name "sql.h" 2>/dev/null
> ./unixODBC-2.3.0/include/sql.h
> ./unixODBC-2.3.0/target/include/sql.h
> 
> yet a matching: --with-unixodbc=/home/grenetie/unixODBC-2.3.0/target gives me:
> 
> configure:14980: gcc -c -g -O2  -D_FREETDS_LIBRARY_SOURCE conftest.c >&5
> conftest.c:69:17: sql.h: No such file or directory
> 
> I could work around this finally by keeping the default /usr/local location. 
> 
> > You can't really bypass unixODBC for DBD::ODBC, well, technically you
> > could but you are at that point muttering strange incantations and
> > sacrificing many a chicken.
> OK will do, we'll spare the chicken;)
>  
> > You could alternately be using DBD::Sybase instead of DBD::ODBC, which
> > bypasses ODBC altogether.
> Yes I considered this option, I'd have to rewrite a number of parameterized 
> queries, unless support for these has been added since.
> 
> > Brian
> 
> Details of the success I have on the other machine: 
> 
> Linux version 2.4.21-63.ELsmp ([email protected]) (gcc 
> version 3.2.3 20030502 (Red Hat Linux 3.2.3-59))
> 
> Since I now had root I kept the original /usr/local and..
> unixodbc: yes
> Woo-hoo!
> 
> So I went with a mere:
> ./configure --with-tdsver=7.2 
> 
> still being ignored: 'TDS version: 5.0'
> 
> The like Craig A. Berry suggested I retrofitted to a 7.1:
> ./configure --with-tdsver=7.1 
> 
> and it was honored.
> 
> 1) are others able to get a 'TDS version: 7.2'? Because on 
> http://www.freetds.org/userguide/config.htm I see:
> 
> --with-tdsver=VER 
> Specifies the default TDS version. (There are a couple of ways to set the TDS 
> version at run-time. This parameter takes effect if no run-time settings are 
> provided.) Acceptable values of VER are 4.2, 4.6, 5.0, 7.0, 7.1 and 7.2.
> The default is 5.0 if this argument is not passed to configure.
> 
> I see 7.2 again on http://www.freetds.org/userguide/choosingtdsprotocol.htm
> 
> 2) Is there really an 8.0 version like http://www.unixodbc.org/doc/FreeTDS.html 
> indicates? Because: 
> 
> 7.2 for SQL Server 2008
> 8.0 the TDS protocol version of MSSQL 2000.
> 
> would mean versioning is going backward? 
> 
> 
> 
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds