Re: SQLServer/ODBC and nested subselects?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JohnD (john_nospam_at_tech-testing.com)
Date: 09/24/04

  • Next message: Andrey: "Re: SQLServer/ODBC and nested subselects?" 
    Date: Fri, 24 Sep 2004 14:33:37 GMT

    Peter Arrenbrecht wrote:
    > We ran into similar problems (see post ODBC Bug in SQL Server 8). When
    > we run our test query against ADO instead of ODBC, we get the same error
    > message. Seems MS-SQL is rather poor when it comes to parameter handling
    > :(.

    You raise an interesting point. I have yet to try it on another db,
    like DB2 or MySQL.

    Thanks,
    John

  • Next message: Andrey: "Re: SQLServer/ODBC and nested subselects?"

    Relevant Pages

    • Re: TADO vs. TQuery
      ... >> I have an application that uses ODBC to connect to MS SQL ... >> this benefit greatly if I changed to ADO? ... It will take a while to 'tune up' ADO objects to get BDE speed. ... Eventually we started using DOA (Direct ...
      (borland.public.delphi.database.ado)
    • Re: ADODB.Connection object not returning correct ConnectonString prop
      ... Opens the connection (successfully) ... I'm not positive but a guess is that ADO is using the MSDASQL Provider to ... provide OLE DB support for ODBC. ... ODBC Driver. ...
      (microsoft.public.data.ado)
    • Re: Problem updating a record containing a negative Value
      ... If it is the same in ADO or ADO.NET then this is definitely a bug in ODBC ... driver from the vendor. ...
      (microsoft.public.data.ado)
    • Re: [Access2003, VBA] Use DAO or ADO?
      ... ODBC, whatever the back end. ... to a jet backend to open a ado recordset. ... customers want/need sql server and another wants to use MySql. ...
      (comp.databases.ms-access)
    • RE: :ODBC vs. DBD::ADO
      ... Subject: ODBC vs. DBD::ADO ... I've never found anything that ADO could do that ODBC couldn't. ... figure out its quirks but for Perl ODBC works perfectly. ... Marble Bar Asset Management LLP is regulated and authorised by the FSA. ...
      (perl.dbi.users)