Knowledge Base

FIX: MDAC 2.0 SQL Server ODBC Driver Hangs On SQLDescribeCol()

Article ID: 201061

Article Last Modified on 10/3/2003

Microsoft ODBC Driver for Microsoft SQL Server 3.5
Microsoft ODBC Driver for Microsoft SQL Server 3.6

This article was previously published under Q201061

BUG #: 50383 (SQLBUG_70)

SYMPTOMS

Applications using the following versions of the Microsoft SQL Server ODBC Driver hang on calls to SQLDescribeCol(), after SQLPrepare() is called, if the prepared SQL statement contains derived tables:

Version 3.50.0305
Version 3.50.0306
Version 3.60.0319

WORKAROUND

Call SQLDescribeCol() after calling SQLExecute() and SQLExecDirect().

NOTE: This problem does not occur in version 2.65.0252 or earlier versions of the driver.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft SQL Server ODBC Driver versions 3.50.0305, 3.50.0306, or 3.60.0319.

This problem was corrected in the Microsoft SQL Server ODBC Driver version 3.70.0623.

MORE INFORMATION

Example

Using ODBCTest connect to the pubs database in SQL Server and call SQLPrepare() on the following query. Next, call SQLDescribeCol() on the first column.

select c35
from (select T1.discounttype c35, sum(T1.discount) c36
      from pubs.dbo.discounts T1 group by T1.discounttype) D2

Keywords: kbbug kbfix kbsqlserv650sp5fix kbdatabase KB201061