FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

Hi, I've been running a few known-to-work examples I have lying around
against the latest in CVS and have another problem.  This one is not a
high priority and I have no suggested fix, but here's something that
used to work but now does not:

Using Linux x86 + Perl + DBI::ODBC (not DBD::Sybase) to MS SQL Server
2000 using TDS 7.0, I used to be able to do some simple queries like:

SELECT @@SERVERNAME AS 'Servername',@@VERSION AS 'Version'

And get:

MSSQL01 | Microsoft SQL Server  2000 - 8.00.534 (Intel X86) 
        Nov 19 2001 13:23:50 
        Copyright (c) 1988-2000 Microsoft Corporation
        Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

This works fine using FreeTDS 0.53-cvs2002-04-06.  But under the latest
from CVS (I'll call it FreeTDS 0.53-cvs2002-07-08), I get instead:

Cannot connect to database
Error 08001 ([unixODBC][Driver Manager]Data source name not found, and
no default driver specified (SQL-IM002)
[unixODBC]Statement option not implemented (SQL-08001)(DBD:
dbd_db_login/SQLSetConnectOption err=-1))

I tried another version of FreeTDS I had hanging around,
0.53-cvs2002-06-19, and that gives the same problem.  So, sometime
between 2002-04-06 and 2002-06-19, I lost the ability to issue even the
simplest query via DBD::ODBC.  The error message is inscrutable to me.
The two outputs where generated on the same machine with the same
odbc.ini, after doing a `make install` in the appropriately versioned
directory so all other variables besides the FreeTDS code should
probably be unrelated.  In case it's useful, all three source trees were
built with:

./autogen.sh --with-tdsver=7.0 --with-unixodbc=/usr

This is not a grave issue for me since I use DBD::Sybase mostly, but I'm
interested in seeing DBD::ODBC work, too.

If I can do any additional tests, please let me know!

Thanks,
Eric



> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Monday, July 08, 2002 12:28 PM
> 
> Brian,
> 
> I think we're about done adding patches for 0.60, and except for the
TEXT
> truncation under 7.0, I think we're feature-complete.  I'm planning on
> scribbling in the UG this week; should be ready by the weekend.  How
do
> things look to you?
> 
> --jkl
> 
> ---
> You are currently subscribed to freetds as:
[edeutsch AT systemsbiology.org]
> To unsubscribe, forward this message to leave-freetds-
> 127899P AT franklin.oit.unc.edu