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
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- AutoGeneratedField.cs
- GuidTagList.cs
- CollectionViewSource.cs
- CacheMemory.cs
- TcpConnectionPoolSettingsElement.cs
- DataSourceCache.cs
- HttpHandlerActionCollection.cs
- AppDomain.cs
- PassportAuthentication.cs
- ToolStripStatusLabel.cs
- ThumbAutomationPeer.cs
- SortDescription.cs
- RegexCharClass.cs
- ZipIOCentralDirectoryDigitalSignature.cs
- XmlSchemaAttribute.cs
- ObjectPersistData.cs
- CustomAttribute.cs
- StringOutput.cs
- Memoizer.cs
- Int16AnimationUsingKeyFrames.cs
- MessagePropertyDescriptionCollection.cs
- MailAddress.cs
- CompilerResults.cs
- EnlistmentState.cs
- Clock.cs
- FigureParagraph.cs
- SqlMetaData.cs
- EntityProxyFactory.cs
- InlineUIContainer.cs
- COM2Enum.cs
- MenuScrollingVisibilityConverter.cs
- IImplicitResourceProvider.cs
- DataGridViewRowErrorTextNeededEventArgs.cs
- CorrelationTokenTypeConvertor.cs
- XomlCompilerParameters.cs
- SourceInterpreter.cs
- StorageEntityContainerMapping.cs
- PointLightBase.cs
- IdentityHolder.cs
- ObjectDataSourceFilteringEventArgs.cs
- CheckedListBox.cs
- CodeConditionStatement.cs
- SqlDelegatedTransaction.cs
- EntityDataReader.cs
- ObjectDisposedException.cs
- BamlMapTable.cs
- IndexingContentUnit.cs
- InkCollectionBehavior.cs
- ProfileInfo.cs
- WebPartMenuStyle.cs
- SrgsRuleRef.cs
- HtmlDocument.cs
- CustomTypeDescriptor.cs
- HtmlUtf8RawTextWriter.cs
- TextWriter.cs
- CRYPTPROTECT_PROMPTSTRUCT.cs
- ThicknessAnimationBase.cs
- CollectionContainer.cs
- BoolLiteral.cs
- ManipulationInertiaStartingEventArgs.cs
- EnglishPluralizationService.cs
- DataKey.cs
- Base64Encoding.cs
- CriticalHandle.cs
- PackagingUtilities.cs
- CodeSubDirectory.cs
- SoapAttributes.cs
- InvalidPipelineStoreException.cs
- TableItemPatternIdentifiers.cs
- EntityDescriptor.cs
- GridPattern.cs
- CompletedAsyncResult.cs
- XamlSerializer.cs
- ThousandthOfEmRealPoints.cs
- CanExecuteRoutedEventArgs.cs
- GridViewRowCollection.cs
- MsmqTransportReceiveParameters.cs
- WebPartConnectionsEventArgs.cs
- ProtocolsConfigurationEntry.cs
- BindingExpressionBase.cs
- SSmlParser.cs
- MarkupCompiler.cs
- TiffBitmapDecoder.cs
- TextSegment.cs
- FunctionImportMapping.cs
- ComponentConverter.cs
- InvokePattern.cs
- ConfigXmlComment.cs
- StylusPointPropertyInfo.cs
- EmbeddedMailObjectsCollection.cs
- AppDomainShutdownMonitor.cs
- EventLogInformation.cs
- RectangleGeometry.cs
- SqlCharStream.cs
- NegationPusher.cs
- AttributeProviderAttribute.cs
- MethodRental.cs
- ListViewCommandEventArgs.cs
- CodeVariableDeclarationStatement.cs
- HttpRuntimeSection.cs