ODBC Bug in SQL Server 8?

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

From: Peter Arrenbrecht (arrenbrecht_at_NOXXX.opus.ch)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 14:45:08 +0200

Hi all

If I prepare the following statement:

SELECT zA."ID" AS fA_A
, zA."IDFirma" AS fA_B
, zA."Name" AS fA_C
, zA."Vorname" AS fA_D
, zA."IDMandant" AS fA_E
, zB."ID" AS fB_A
FROM AtlasTest.Adresse AS zA
INNER JOIN AtlasTest.Mandant AS zB
   ON zB."ID" = zA."IDMandant" AND (zB."ID" = ?)
WHERE zA."IDFirma" = 1
ORDER BY 1

the ODBC driver then returns 0 in SQLNumResultCols. If I change the "?"
to "1", however, everything works ok (6 cols). It even works if I use a
"?" in the where clause.

SQL Server Version is 8.00.760 (SP3).

Any clues?

Regards,
Peter Arrenbrecht
Opus Software AG

Relevant Pages

  • RE: Undeliverable Email (pop3 connector)
    ... if you have found any clues. ... Good luck! ... Best regards, ... MCSE2000 MCDBA CCNA ...
    (microsoft.public.windows.server.sbs)
  • FC4 and No logs
    ... secure etc hasn't logged anything since yesterday. ... Anyone got any clues? ... With best regards ... Tomas Larsson ...
    (Fedora)
  • Help: Question on corrugated fibreboard
    ... There are several versions already on the market but they are not all ... that satisfactory. ... Any clues? ... Regards to all ...
    (sci.materials)
  • RE: New WebDAV Problems
    ... Please reproduce the error for several times and collect IIS log in ... We should be able to find clues from it. ... Best regards, ... WenJun Zhang ...
    (microsoft.public.inetserver.iis)