1. Forum
  2. Usenet
  3. COMP.SOFT-SYS.APP-BUILDER

  • [U-L] Message error - SQL Server 7.0

    From purplefishit@gmail.com@21:1/5 to Vanessa Medeiros on Wed Oct 7 05:09:27 2015
    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_medeiros@allianceconsultoria.com.br http://www.allianceconsultoria.com.br

    Enable heterogeneous queries in your ASN:

    [DRIVER_SETTINGS]

    USYS$MSS_PARAMS=sql92npw = on

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)