Conformance
Version Introduced: ODBC 1.0
Summary
SQLWriteDSNToIni adds a data source to the system information.
Syntax
BOOL SQLWriteDSNToIni(
LPCSTR lpszDSN,
LPCSTR lpszDriver);
Arguments
lpszDSN
[Input]
Name of the data source to add.
lpszDriver
[Input]
Driver description (usually the name of the associated DBMS) presented to users instead of the physical driver name.
Returns
The function returns TRUE if it is successful, FALSE if it fails.
Diagnostics
When SQLWriteDSNToIni returns FALSE, an associated *pfErrorCode value may be obtained by calling SQLInstallerError. The following table lists the *pfErrorCode values that can be returned by SQLInstallerError and explains each one in the context of this function.
| *pfErrorCode | Error | Description |
| ODBC_ERROR_ GENERAL_ERR |
General installer error | An error occurred for which there was no specific installer error. |
| ODBC_ERROR_ INVALID_DSN |
Invalid DSN | The lpszDSN argument contained a string that was invalid for a DSN. |
| ODBC_ERROR_ INVALID_NAME |
Invalid driver or translator name | The lpszDriver argument was invalid. |
| ODBC_ERROR_ REQUEST_ FAILED |
Request failed | The installer failed to create a DSN in the registry. |
| ODBC_ERROR_ OUT_OF_MEM |
Out of memory | The installer could not perform the function because of a lack of memory. |
Comments
SQLWriteDSNToIni adds the data source to the [ODBC Data Sources] section of the system information. It then creates a specification section for the data source and adds a single keyword (Driver) with the name of the driver DLL as its value. If the data source specification section already exists, SQLWriteDSNToIni removes the old section before creating the new one.
The caller of this function must add any driver-specific keywords and values to the data source specification section of the system information.
If the name of the data source is Default, SQLWriteDSNToIni also creates the default driver specification section in the system information.
This function should only be called from a setup DLL.
Related Functions
| For information about | See |
| Adding, modifying, or removing a data source | ConfigDSN (in the Setup DLL) |
| Adding, modifying, or removing a data source | SQLConfigDataSource |
| Removing a data source name from the system information | SQLRemoveDSNFromIni |