FreeTDS Development Group

[Perl_to_SQL_Server <JGrenetier AT hotmail.com>]

> 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 (mockbuild AT x86-005.build.bos.redhat.com) (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?