FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
> Sent: February 27, 2004 2:27 PM
> 
> Some time ago I added this option (-Wl,-Bsymbolic) and 
> symbols filter to
> dblib/ctlib Makefiles. However James say that this cause a lot of
> warnings compiling and comment it. Today I tested by myself and I got
> same problem... Looking at configure execution I saw
> 
> checking whether -lc should be explicitly linked... yes
> 
> however compiling shared library libtool seems to NOT include 
> explicitly
> -lc !! -Wl,-Bsymbolic tell the linker to try to resolve all symbols
> dependency at link time. This reduce load time however do not allowing
> symbols overriding (IMHO not a real problem). 

Talk about timing!  I just installed our ODBC driver for the first time, and 
was having trouble linking it.  I was missing the libc symbols.  Because of 
your message, I added "-lc" to the Makefile:

        $ grep ^LD src/odbc/Makefile
        LDFLAGS =  -L/usr/local/lib -lc

and voila, it installed.  

I think we might be able to work around this by adding "-lc" to LDFLAGS in 
Makefile.am.  

BTW, we're experiencing difficulty with unixODBC-2.2.6 and FreeTDS 0.62.1.  
Inserting a row (very simple) row via a stored procedure:

    $dbh->do(execute testdb..a_insert 5)  
                # proc's SQL: "insert a values (5)"

yields:

        DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid 
cursor state (SQL-24000)(DBD: st_execute/SQLRowCount err=-1) at 
/usr/users/production/bin//dbinterface line 458, <GEN0> line 1.

We're still trying to isolate the problem.  It's somewhere in unixodbc, 
because the FreeTDS log shows no error.  Speculation: it might be 64-bit 
related.  

--jkl

-----------------------------------------
The information contained in this transmission may contain privileged and 
confidential information and is intended only for the use of the person(s) 
named above. If you are not the intended recipient, or an employee or agent 
responsible for delivering this message to the intended recipient, any 
review, dissemination, distribution or duplication of this communication is 
strictly prohibited. If you are not the intended recipient, please contact 
the sender immediately by reply e-mail and destroy all copies of the original 
message. Please note that we do not accept account orders and/or instructions 
by e-mail, and therefore will not be responsible for carrying out such orders 
and/or instructions.
If you, as the intended recipient of this message, the purpose of which is to 
inform and update our clients, prospects and consultants of developments 
relating to our services and products, would not like to receive further 
e-mail correspondence from the sender, please "reply" to the sender 
indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New York, 
NY 10105.