Skip to Content.
Sympa Menu

freetds - RE: pre2?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Eric Deutsch" <edeutsch AT systemsbiology.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: pre2?
  • Date: Mon, 8 Jul 2002 15:14:35 -0700



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




Archive powered by MHonArc 2.6.24.

Top of Page