www.mimer.com/developer

6.1 SQLConfigDataSource

---

The following specification of SQLConfigDataSource is from the Microsoft ODBC SDK Reference.

Summary

SQLConfigDataSource adds, modifies, or deletes data sources.

Syntax

BOOL SQLConfigDataSource( 
HWND hwndParent, 
WORD fRequest, 
LPCSTR lpszDriver, 
LPCSTR lpszAttributes); 

Arguments

hwndParent [Input] 

Parent window handle. The function will not display any dialog boxes if the handle is null.

fRequest [Input] 

Type of request.

fRequest must contain one of the following values:

ODBC_ADD_DSN: Add a new user data source.

ODBC_CONFIG_DSN: Configure (modify) an existing user data source.

ODBC_REMOVE_DSN: Remove an existing user data source.

ODBC_ADD_SYS_DSN: Add a new system data source.

ODBC_CONFIG_SYS_DSN: Modify an existing system data source.

ODBC_REMOVE_SYS_DSN: Remove an existing system data source.

ODBC_REMOVE_DEFAULT_DSN: Remove the default data source specification section from the system information. It also removes the default driver specification section from the ODBCINST.INI entry in the system information.
(This fRequest performs the same function as the deprecated SQLRemoveDefaultDataSource function.)
When this option is specified, all of the other parameters in the call to SQLConfigDataSource should be NULLs. If they are not NULL, they will be ignored.

lpszDriver [Input] 

Driver description (usually the name of the associated DBMS) presented to users instead of the physical driver name.

lpszAttributes [Input] 

List of attributes in the form of keyword-value pairs.

Returns

The function returns TRUE if it is successful, FALSE if it fails.

If no entry exists in the system information when this function is called, the function returns FALSE.

Diagnostics

When SQLConfigDataSource 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_HWND	Invalid window handle.	The hwndParent argument was invalid.
ODBC_ERROR_ INVALID_REQUEST_ TYPE	Invalid type of request.	The fRequest argument was not one of the following: ODBC_ADD_DSN ODBC_CONFIG_DSN ODBC_REMOVE_DSN ODBC_ADD_SYS_DSN ODBC_CONFIG_SYS_DSN ODBC_REMOVE_SYS_DSN ODBC_REMOVE_DEFAULT_DSN
ODBC_ERROR_ INVALID_NAME	Invalid driver or translator name.	The lpszDriver argument was invalid. It could not be found in the registry.
ODBC_ERROR_ INVALID_KEYWORD_ VALUE	Invalid keyword value pairs.	The lpszAttributes argument contained a syntax error.
ODBC_ERROR_ REQUEST_FAILED	Request failed.	The installer could not perform the operation requested by the fRequest argument. The call to ConfigDSN failed.
ODBC_ERROR_ LOAD_LIBRARY_ FAILED	Could not load the driver or translator setup library.	The driver setup library could not be loaded.
ODBC_ERROR_ OUT_OF_MEM	Out of memory.	The installer could not perform the function because of a lack of memory.

Comments

SQLConfigDataSource uses the value of lpszDriver to read the full path of the setup DLL for the driver from the system information. It loads the DLL and calls ConfigDSN with the same arguments that were passed to it.

SQLConfigDataSource returns FALSE if it is unable to find or load the setup DLL, or if the user cancels the dialog box. Otherwise, it returns the status it received from ConfigDSN.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se