SQLAllocEnv.md

Home

Function name : SQLAllocEnv

Group: ODBC API - Library: odbc32

---

In ODBC 3.x, the ODBC 2.x function SQLAllocEnv has been replaced by SQLAllocHandle.

---

Code examples:

Enumerating ODBC Data Sources available on the local computer
Enumerating ODBC drivers available on the local computer
Testing an ODBC connection for supporting specific functionality
Using vendor-neutral SQL constructs
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
Retrieveing general information about the driver and data source associated with an ODBC connection
Establishing connection using the SQLDriverConnect
Obtaining list of tables stored in an ODBC Data Source

Declaration:

SQLRETURN SQLAllocEnv(
	SQLHANDLE * OutputHandlePtr);  

---

FoxPro declaration:

DECLARE SHORT SQLAllocEnv IN odbc32;
	INTEGER @ env  

---

Parameters:

OutputHandlePtr [Output] Pointer to a buffer in which to return the handle to the newly allocated data structure.

---

Return value:

SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO, SQL_INVALID_HANDLE, or SQL_ERROR.

---