FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Eric,

can you send the relevent portions of your odbc.ini file and which version 
of unixODBC you are running?  Does this problem show up under isql (or is 
it odbctest...unixodbc, iodbc i forget)

Brian

On Mon, 8 Jul 2002, Eric Deutsch wrote:

> 
> 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
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>