Re: D5 + SQLSERVER



Vitali,

do you have an example to use this option in ado ?

Thank you

JM

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> a écrit dans le message de
news:446d7de9$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Jean-Michel Granier" <jmgway@xxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:446d7bae@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello Vitali,


no the problem is the same inside SqlAnalyser (sqlserver 2005).

regards,

Jean-Michel


Sure it is same since QA use ODBC, thus assigns CONCAT_NULL_YIELDS_NULL to
ON, which is done by OLEDB provider also, but not done by BDE. You can
play
with Connection Properties in QA switch off "Set concat_null_yields null"
and see if it will make any difference.




.



Relevant Pages

  • Re: ColdFusion
    ... adocst.axes.item(it's in ColdFusion syntax). ... > the ADO for Multidimensional Objects driver instead of ADO. ... >> I've tried adding the datasource under SQL Server but am getting the ... >> Regards, ...
    (microsoft.public.sqlserver.olap)
  • Re: Pb while closing ADO query
    ... version of MDAC (Microsoft Data Access Components) is installed on your ... Regards, ... > Thanks Michael ... > We installed the ADO upgrade for Delphi 5 and the ADO update 2; ...
    (borland.public.delphi.database.ado)
  • Re: Where does "MoveNext" belong to?
    ... I do not know anything special about ADO, but try the more usual way to fetch results: ... my $tab4l; ... Best regards ...
    (perl.dbi.users)
  • Re: ADO and too many Handles
    ... Found out that it was a known bug in ... > a SQLServer 2003 and two programs using ADO. ... > the writer is blocked. ...
    (microsoft.public.data.ado)
  • Re: Filter error... but why?
    ... Regards, Mike Niemann ... >ADO does not support filters in form A AND. ... you would construct this filter as ... >> Regards, Mike Niemann ...
    (borland.public.delphi.database.ado)