Skip to Content.
Sympa Menu

freetds - Heterogeneous queries?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Barnard Foo" <foo AT vircom.com.au>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Heterogeneous queries?
  • Date: Fri, 5 Jan 2001 03:18:55 -0500


I am using the FreeTDS JDBC driver on a Linux box with Macromedia
Generator to connect to an SQL Server 7 database running on NT. Most
of my queries run fine, but I have a problem with one or two stored
procedures. (But ONLY with the FreeTDS driver, not other JDBC drivers).

Generator returns 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

However, SQL Server Query Analyser returns 'Warning: Null value
eliminated from aggregate' so I'm not sure if the JDBC driver is at
fault.


Any ideas would be greatly appreciated,

Barnard.



  • Heterogeneous queries?, Barnard Foo, 01/05/2001

Archive powered by MHonArc 2.6.24.

Top of Page