OdbcEnvironmentHandle.cs source code in C# .NET

Source code for the .NET framework in C#

                        
Code:

                         / Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / ndp / fx / src / Data / System / Data / Odbc / OdbcEnvironmentHandle.cs / 1 / OdbcEnvironmentHandle.cs
                        

                        
                            //------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
using System;
using System.Collections; 
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Diagnostics; 
using System.Globalization;
using System.Runtime.InteropServices; 
using System.Security; 
using System.Security.Permissions;
using System.Text; 
using System.Threading;

namespace System.Data.Odbc {
 
    sealed internal class OdbcEnvironmentHandle : OdbcHandle {
 
        internal OdbcEnvironmentHandle() : base(ODBC32.SQL_HANDLE.ENV, null) { 
            ODBC32.RetCode retcode;
 
            //Set the expected driver manager version
            //
            retcode = UnsafeNativeMethods.SQLSetEnvAttr(
                this, 
                ODBC32.SQL_ATTR.ODBC_VERSION,
                ODBC32.SQL_OV_ODBC3, 
                ODBC32.SQL_IS.INTEGER); 
            // ignore retcode
 
            //Turn on connection pooling
            //Note: the env handle controls pooling.  Only those connections created under that
            //handle are pooled.  So we have to keep it alive and not create a new environment
            //for   every connection. 
            //
            retcode = UnsafeNativeMethods.SQLSetEnvAttr( 
                this, 
                ODBC32.SQL_ATTR.CONNECTION_POOLING,
                ODBC32.SQL_CP_ONE_PER_HENV, 
                ODBC32.SQL_IS.INTEGER);

            switch(retcode) {
            case ODBC32.RetCode.SUCCESS: 
            case ODBC32.RetCode.SUCCESS_WITH_INFO:
                break; 
            default: 
                Dispose();
                throw ODBC.CantEnableConnectionpooling(retcode); 
            }
        }
    }
} 


// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
using System;
using System.Collections; 
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Diagnostics; 
using System.Globalization;
using System.Runtime.InteropServices; 
using System.Security; 
using System.Security.Permissions;
using System.Text; 
using System.Threading;

namespace System.Data.Odbc {
 
    sealed internal class OdbcEnvironmentHandle : OdbcHandle {
 
        internal OdbcEnvironmentHandle() : base(ODBC32.SQL_HANDLE.ENV, null) { 
            ODBC32.RetCode retcode;
 
            //Set the expected driver manager version
            //
            retcode = UnsafeNativeMethods.SQLSetEnvAttr(
                this, 
                ODBC32.SQL_ATTR.ODBC_VERSION,
                ODBC32.SQL_OV_ODBC3, 
                ODBC32.SQL_IS.INTEGER); 
            // ignore retcode
 
            //Turn on connection pooling
            //Note: the env handle controls pooling.  Only those connections created under that
            //handle are pooled.  So we have to keep it alive and not create a new environment
            //for   every connection. 
            //
            retcode = UnsafeNativeMethods.SQLSetEnvAttr( 
                this, 
                ODBC32.SQL_ATTR.CONNECTION_POOLING,
                ODBC32.SQL_CP_ONE_PER_HENV, 
                ODBC32.SQL_IS.INTEGER);

            switch(retcode) {
            case ODBC32.RetCode.SUCCESS: 
            case ODBC32.RetCode.SUCCESS_WITH_INFO:
                break; 
            default: 
                Dispose();
                throw ODBC.CantEnableConnectionpooling(retcode); 
            }
        }
    }
} 


// File provided for Reference Use Only by Microsoft Corporation (c) 2007.

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK