Microsoft KB Archive/201061

= FIX: MDAC 2.0 SQL Server ODBC Driver Hangs On SQLDescribeCol =

Article ID: 201061

Article Last Modified on 10/3/2003

-

APPLIES TO


 * 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.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.