Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: [U-L] Message error - SQL Server 7.0

21 views
Skip to first unread message

purple...@gmail.com

unread,
Oct 7, 2015, 8:09:28 AM10/7/15
to
On Tuesday, October 17, 2000 at 8:00:00 AM UTC+1, Vanessa Medeiros wrote:
> Hi,
>
> 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?
>
> Thanks,
>
> Vanessa Medeiros
> Alliance Consultoria - phone: 55-11-5507-7722
> e-mail: vanessa_...@allianceconsultoria.com.br
> http://www.allianceconsultoria.com.br

Enable heterogeneous queries in your ASN:

[DRIVER_SETTINGS]

USYS$MSS_PARAMS=sql92npw = on
0 new messages