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

SQLSetEnvAttr (odbc32)
 
.
Summary
SQLSetEnvAttr sets attributes that govern aspects of environments.

C# Signature:

[DllImport("odbc32.dll", SetLastError=true)]
static extern short SQLSetEnvAttr (
    IntPtr envHandle,
    int attribute,
    IntPtr attrValue,
    int stringLength );

Alternate C# Signature:

[DllImport("odbc32.dll", SetLastError=true)]

static extern short SQLSetEnvAttr (
    IntPtr envHandle,
    int attribute,
    ushort attribute,
    int    attrValue,
    int stringLength );

VB Signature:

Private Declare Auto Function SQLSetEnvAttr Lib "odbc32.dll" ( _
    ByVal henv As IntPtr, _
    ByVal attribute As Integer, _
    ByVal valuePtr As IntPtr, _
    ByVal strLength As Integer ) As Short

Notes:

Simple attributes are passed in the pointer itself, hence the overloaded signature.

Tips & Tricks:

We hit a bug with getting odbc data sources under 64 bit. Oddly it only seemed to affect people with visual studio 2012 installed. Maybe the problem is with .NET framework 4.5. The c# signatures had "ushort attribute" and we changed it to "int attribute". Then things seemed to work for people with Visual Studio 2010 or 2012.

Sample Code:

Please add some!

Alternative Managed API:

Do you know one? Please contribute it!

Sample Code:

Please add some!

Alternative Managed API:

Do you know one? Please contribute it!

Documentation

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