On Tuesday, October 17, 2000 at 8:00:00 AM UTC+1, Vanessa Medeiros wrote:
> I have a problem using Uniface 7.2.05 with SQL Server 7 thru ODBC.
> 1. I have a table in a server.
> 2. I have a view in other server that access this table.
> This message error appears to me:
> 42000 [Microsoft ODBC SQL Server Driver] [SQL Server]
> Heterogeneous queries require the ANSI-nulls and
> ANSI-warnings options to be for the connection.
> This ensures consistent query semantics.
> Enable these options and reissue your query.
> When I had Uniface 7.2.04, no problems...
> The ANSI-nulls and ANSI-warnings are enable in SQL Server.
> Somebody knows what is happened?
> Vanessa Medeiros
> Alliance Consultoria - phone: 55-11-5507-7722
> e-mail: vanessa_...@allianceconsultoria.com.br
Enable heterogeneous queries in your ASN:
USYS$MSS_PARAMS=sql92npw = on