FreeTDS Development Group

["Barnard Foo" <foo AT vircom.com.au>]

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.