Search
Module:
Directory

   Desktop Functions:

   Smart Device Functions:


Show Recent Changes
Subscribe (RSS)
Misc. Pages
Comments
FAQ
Helpful Tools
Playground
Suggested Reading
Website TODO List
Download Visual Studio Add-In

SQLAllocEnv (odbc32)
 
.
Summary
SQLAllocEnv allocates memory for an environment handle and initializes the ODBC call level interface for use by an application. An application must call SQLAllocEnv prior to calling any other ODBC function.

C# Signature:

[DllImport("odbc32.dll")]
static extern short SQLAllocEnv(out IntPtr EnvironmentHandle);
public static extern short SQLAllocEnv(out IntPtr EnvironmentHandle);

VB Signature:

User-Defined Types:

    //return values
    const short SQL_SUCCESS             =   0;
    const short SQL_SUCCESS_WITH_INFO   =   1;    
    const short SQL_STILL_EXECUTING     =   2;
    const short SQL_NEED_DATA           =  99;
    const short SQL_NO_DATA             = 100;
    const short SQL_ERROR               = (-1);
    const short SQL_INVALID_HANDLE      = (-2);

Alternative Managed API:

Do you know one? Please contribute it!

Notes:

None.

Tips & Tricks:

Please add some!

Alternative Managed API:

Do you know one? Please contribute it!

Sample Code:

Notes:

None.

    IntPtr environmentHandle = IntPtr.Zero;
    short  rc = SQLAllocEnv(out environmentHandle);
    if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
    {
        throw new Exception("Failed to allocate environment handle.");
    }

Tips & Tricks:

Please add some!

Sample Code:

    IntPtr environmentHandle = IntPtr.Zero;
    short  rc = SQLAllocEnv(out environmentHandle);
    if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
    {
        throw new Exception("Failed to allocate environment handle.");
    }

Documentation
SQLAllocEnv on MSDN

Please edit this page!

Do you have...

  • helpful tips or sample code to share for using this API in managed code?
  • corrections to the existing content?
  • variations of the signature you want to share?
  • additional languages you want to include?

Select "Edit This Page" on the right hand toolbar and edit it! Or add new pages containing supporting types needed for this API (structures, delegates, and more).

 
Access PInvoke.net directly from VS:
Terms of Use
Edit This Page
Find References
Show Printable Version
Revisions