Conformance
Version Introduced: ODBC 3.0
Summary
SQLWriteFileDSN writes information to a File DSN.
Syntax
BOOL SQLWriteFileDSN(
LPCSTR lpszFileName,
LPCSTR lpszAppName,
LPCSTR lpszKeyName,
LPCSTR lpszString);
Arguments
lpszFileName
[Input]
Pointer to the name of the File DSN. A DSN extension is appended to all file names that do not already have a DSN extension.
lpszAppName
[Input]
Pointer to the name of the application. This is “ODBC” for the ODBC section.
lpszKeyName
[Input]
Pointer to the name of the key to be read. See “Comments” for reserved keywords.
lpszString
[Output]
Pointed to the string associated with the key to be written. The maximum length of the string pointed to by this argument is 32,767 bytes.
Returns
The function returns TRUE if it is successful, FALSE if it fails.
Diagnostics
When SQLWriteFileDSN 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_ PATH |
Invalid install path | The path of the file name specified in the lpszFileName argument was invalid. |
ODBC_ERROR_ INVALID_ REQUEST_TYPE |
Invalid type of request | The lpszAppName, lpszKeyName, or lpszString argument was NULL. |
Comments
ODBC reserves the section name [ODBC] in which to store the connection information. The reserved keywords for this section are the same as those reserved for a connect string in SQLDriverConnect (for more information, see the SQLDriverConnect function description).
Applications may use these reserved keywords to write information directly to a File DSN. If an application wants to create or modify the DSN-less connection string associated with a File DSN, it can call SQLWriteFileDSN for any of the reserved connection string keywords in the [ODBC] section.
If the lpszString argument is a null pointer, the keyword pointed to by the lpszKeyName argument will be deleted from the .dsn file. If the lpszString and lpszKeyName arguments are both null pointers, the section pointed to by the lpszAppName argument will be deleted from the .dsn file.
Related Functions
For information about | See |
Reading information from File DSNs | SQLReadFileDSN |