Re: [Microsoft][ODBC SQL Server Driver]Optional feature not implememted

From: Damien THOUVENIN (damien_at_thouvenin.net)
Date: 12/20/04

  • Next message: Del M: "Re: Use query or stored procedure" 
    Date: Mon, 20 Dec 2004 14:56:25 +0100

    Try updating your MDAC version; I had similar problems with parameters in
    sub-select SQL statements on some machines and not on the others; I finally
    found that the machines running MDAC 2.7 or above don't raise the exception.

    "Mike" <myqro@yahoo.com> a écrit dans le message de news:
    411854f8@newsgroups.borland.com...
    > Hi,
    > I have tried all the suggestions but nothing seems to work, (But I am not
    > getting the ODBC Error now). That is I am not getting the results for the
    > query. If I run the same query in the query analyser of SQL I get my
    > result.
    >
    > Any more suggestions???
    >
    > Thanks,
    > Mike
    > "Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
    > news:n0fgh0l04h8e50k43h5p6digahsqp43n4v@4ax.com...
    >>
    >> >Is there anybody who can hel in resolving this error.
    >> >
    >> >I am using MSSQL 2000 and Delphi 7 enterprise. This error appears when I
    >> >execute the following TADOQuery:
    >>
    >> I suggest you use the OleDB driver for SQL server
    >> There are database features that don't work with ODBC
    >> --
    >> Brian Bushay (TeamB)
    >> Bbushay@NMPLS.com
    >
    >

  • Next message: Del M: "Re: Use query or stored procedure"

    Relevant Pages

    • Re: DTS Data Pump VBScript runtime error Type mismatch
      ... replaced the SQL Source Query in the Data Driven Query Object from: ... up using "Lookup" objects rather than doing it all at once in a single SQL ... What was working fine on all machines, ...
      (microsoft.public.sqlserver.dts)
    • RE: Internal Connection Fatal Error - VS 2003 and SQL 2000
      ... Our setup is Win 2003 Server IIS and Win 2000 SQL. ... I've found that the version of MDAC is different on the two machines. ...
      (microsoft.public.vstudio.development)
    • RE: Internal Connection Fatal Error - SQL 2000 and ASP VS 2003
      ... Our setup is Win 2003 Server IIS and Win 2000 SQL. ... I've found that the version of MDAC is different on the two machines. ...
      (microsoft.public.sqlserver.connect)
    • Re: DBMS and lisp, etc.
      ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
      (comp.lang.lisp)
    • Re: Populating a list -- table structure?
      ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
      (microsoft.public.access.forms)