FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Mon, 8 Jul 2002 15:14:35 -0700, "Eric Deutsch"
<edeutsch AT systemsbiology.org> 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'
[snip]
> 
> 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 noticed a similar problem and assumed my unixodbc setup was wrong.  It
never worked, but I installed it only recently.  

$ isql sandbox -v
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified
[ISQL]ERROR: Could not SQLConnect

I think I followed the directions on www.unixodbc.org, but I haven't found
where if anywhere odbcinst is writing to.  It claims to be writing to a
file ODBC.INI, but there nonesuch on my system.  

--jkl