Microsoft KB Archive/133015

= BUG: Use of Apostrophes in DSN Setup Not Allowed =

Article ID: 133015

Article Last Modified on 7/27/2001

-

APPLIES TO


 * Microsoft Open Database Connectivity 2.0

-



This article was previously published under Q133015



BUG# QJET: 2242 (2.00.2317)



SYMPTOMS
When you use an apostrophe in the data source name (DSN) for a DSN definition with an ODBC Desktop Database Driver version 2.0 driver, that DSN cannot be accessed later using the Setup button of the ODBC Administrator. This type of DSN also causes the ODBC Administrator to return an incorrect error message when you try to delete the DSN with the Delete button in the ODBC Administrator.

The ODBC Administrator returns the message:

The ODBC driver could not entirely delete the data source. Do you want to remove the entry anyway?



WORKAROUND
Do not use apostrophes in data source names for the ODBC Desktop Database Drivers version 2.0. If you want to use apostrophes in a DSN, you can do so and use the DSN with ODBC, but it cannot be modified later using the Setup button of the ODBC Administrator.



STATUS
Microsoft has confirmed this to be a problem in ODBC Desktop Database Drivers version 2.00.2317. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 2.00.2317

Keywords: kbbug KB133015

-

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

© Microsoft Corporation. All rights reserved.