Article ID: 295739 - Last Review: November 14, 2003 - Revision: 3.2

BUG: DTS Designer May Stop Responding When You Use Microsoft Jet 4.0 OLE DB Provider

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q295739
BUG #: 209139 (SHILOH)
Expand all | Collapse all

SYMPTOMS

When you import to or export data from a Microsoft Access database, the SQL Server Data Transformation Services (DTS) Designer or the Import/Export wizard may seem to stop responding (hang), and then exit prematurely. When you are working in the DTS Designer, you may encounter this problem when you retrieve properties by right-clicking the Transform Data Task arrow. The Import/Export wizard just disappears from the monitor.
Back to the top

CAUSE

The symptoms exposed by this problem are caused by an unhandled access violation that occurs when information is retrieved from the IDBSchemaRowset object of the Microsoft Jet 4.0 OLE DB Provider.
Back to the top

WORKAROUND

As a workaround, change the values set to (NULL) in the SELECT list to a another value such as EMPTY, depending on the requirements of your application.
Back to the top

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Back to the top

MORE INFORMATION

This behavior may occur when the Microsoft Access database contains a UNION query similar to the following: 
SELECT DISTINCT
     ID,
     C1,
     C2,
     C3
FROM T1
UNION ALL 
SELECT DISTINCT
     ID,
     C1,
     C2,
     (NULL)
FROM T2;
The problem exposes itself due to the default (NULL) value in the SELECT list of the UNION queries.
Back to the top
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft OLE DB Provider for Jet 4.0
Back to the top
Keywords: 
kbbug kbfaq kbpending KB295739
Back to the top