Microsoft KB Archive/235889

= BUG: Adding a DSN With Microsoft Text Driver May Fail =

Article ID: 235889

Article Last Modified on 9/22/2003

-

APPLIES TO


 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q235889



SYMPTOMS
When you try to create a data source name (DSN) with the Microsoft Text Driver on a computer that has MDAC 2.1 or later installed, you may get the following error:

Failed to save table attributes of (null) into (null).



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
This behavior is inconsistent. The error may occur when you try to create a USER DSN and then it might occur when you to create a System DSN.

The error only occurs when adding a DSN.

NOTE: You can ignore the error and save the DSN. Then you can reconfigure the same DSN without getting an error.

Steps to Reproduce the Error
 Install MDAC 2.1 or later. Create a text file named TestDSN.csv using Notepad. Enter "1,2,3,4" in the text file and then save the file. The file name and content are not important. Open Control Panel and click the ODBC icon and add a User or System DSN. Select "Microsoft Text Driver (*.txt;*.csv)". Enter a data source name and clear the "Use Current Directory" check box. Select the directory where the TestDSN.csv file was saved as the current directory.</li> Click the Option button.</li> Click Define Format.</li> Select the file TestDSN.csv.</li> Select the CSV format (since the file you created is CSV delimited, otherwise it is not important).</li> Click Guess, which will give the field names, and so forth.</li> Next, click OK. You will then get the error:

Failed to save table attributes of (null) into (null).

</li></ol>

Keywords: kbbug kbmdacnosweep kbpending KB235889

-

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

© Microsoft Corporation. All rights reserved.