BUG: SQLConfigDataSource Returns TRUE Even Without Registry Permissions (294177)
The information in this article applies to:
- Microsoft Data Access Components 2.1
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.7
- Microsoft Open Database Connectivity 3.5
This article was previously published under Q294177 IMPORTANT: This article contains information about modifying the registry. Before you
modify the registry, make sure to back it up and make sure that you understand how to restore
the registry if a problem occurs. For information about how to back up, restore, and edit the
registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
SYMPTOMS
When you use the ODBC API function SQLConfigDataSource to add, modify, or delete a data source (DSN), SQLConfigDataSource may return TRUE even though you don't have the appropriate permissions and the operation was not completed.
CAUSESQLConfigDataSource attempts to update the registry key where this information is stored.
For a user DSN:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
For a system DSN:
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI
If you do not have read/write access to the registry, the DSN information cannot be updated but SQLConfigDataSource incorrectly returns TRUE.
STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 5/10/2003 |
---|
Keywords: | kbbug kbnofix KB294177 |
---|
|