Skip to Content.
Sympa Menu

freetds - broken odbc (was: pre2?)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
  • Cc: edeutsch AT systemsbiology.org
  • Subject: broken odbc (was: pre2?)
  • Date: Mon, 8 Jul 2002 20:31:43 -0400


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



  • broken odbc (was: pre2?), James K. Lowden, 07/08/2002

Archive powered by MHonArc 2.6.24.

Top of Page