freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Even simple queries fail!

From: "Barnard Foo" <foo AT vircom.com.au>
To: freetds AT franklin.oit.unc.edu
Subject: Even simple queries fail!
Date: Sun, 14 Jan 2001 20:20:56 -0500

I have been using the FreeTDS libraries with Perl
(DBD:Sybase) and the FreeTDS JDBC driver with
Macromedia Generator to connect to an SQL Server
7 database. Some queries run OK, but most (even really
simple ones) return the following error message:

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options
to be set for the connection. This ensures consistent query semantics.
Enable these options and then reissue your query

Does anyone know what this means?

Even simple queries fail!, Barnard Foo, 01/14/2001