Skip to Content.
Sympa Menu

freetds - Re: [freetds] unixodbc: no ??

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Perl_to_SQL_Server <JGrenetier AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] unixodbc: no ??
  • Date: Wed, 12 Oct 2011 16:17:41 +0000 (UTC)

> 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?







Archive powered by MHonArc 2.6.24.

Top of Page