New Oracle Features for. NET by Release. New ODP. NET Features by Release. Version 1. 2. 2. 0. ODAC 1. 2. 2 Release 1. NET Framework 4. 7 Certification. Entity Framework 6. Certification. Database Resident Connection Pooling. This tutorial shows you how to install the Oracle Database 12c software on Microsoft Windows along with a default instance of an Oracle Database that contains example. Multitenant and Pluggable Databases Connection Pooling. Edition Based Redefinition Connection Pooling. Connection Configuration Upon Open. Version 1. 2. 2. 0. NET Framework 4. 6. Certification. Application Continuity unmanagedSharding and ODP. NET Routing unmanagedLonger Schema Identifiers. New. NET Features for Oracle Database The list below details when specific new Oracle. NET features were introduced. It does not cover bug fixes nor minor changes. ODP. NET PLSQL Boolean Data Type managedVersion 1. Nu. Get September, 2. ODP. NET, Managed Driver can connect to Oracle Database Exadata Express Cloud Service. Version 1. 2. 1. 0. Nu. Get April, 2. Data IntegrityChecksumming managedTransport Layer Security TLS 1. Configuration settings with relative Windows Paths and Windows Environment Variables managedSearch for. ORA files in. EXE directory before looking in current working directory managedVersion 1. ODAC 1. 2c Release 4. NET Framework 4. 6 and 4. Windows installer managedNetwork data encryption managedSecure External Password Store managedMicrosoft Local Security Authority managed MSLSA Kerberos credential cache. SSLTLS Connections Use a Single Port managedService Relocation Connection Timeout Avoid connection attempts to an unavailable service. Transaction Guard unmanaged Less application code needed to manage transaction recovery. Transaction Guard managedFully Managed Code for Distributed Transactions unmanagedSQL Translation Framework unmanaged Migrate vendor proprietary SQL syntax to semantically equivalent Oracle syntax. Tracing Improves and unifies tracing features between managed and unmanaged ODP. NETVersion 1. 2. 1. ODAC 1. 2c Release 3. Entity Framework 6 certification. Entity Framework 6 Code First. Entity Framework 6 Code First Migrations. Nu. Get package managedXML DB support managedDistributed transactions without Oracle. Managed. Data. Access. DTC. dll managedKerberos managedVersion 1. NET Framework 4. 5. Character data types increased to 3. KB managedReturn number of rows affected from each input in array binding operations managedVersion 1. ODAC 1. 2c Release 2. NET Framework 4. 5. More easily distinguish ODP. NET, Managed Driver versions. Version 1. 2. 1 in ODAC 1. Release 1. LDAP Connections to Active Directory and Oracle Internet Directory managedVersion 1. Oracle Database 1. ODP. NET, Managed Driver. Multitenant container database support in Oracle Database 1. Auto increment Identity column support unmanagedCharacter data types increased to 3. KB unmanagedODP. NET PLSQL Boolean data type unmanagedEnhanced implicit REF Cursor binding. Return number of rows affected from each input in array binding operations unmanagedLINQ SQL APPLY keyword support for lateral views. Transaction Guard support Ensures transactions commit at most once even after outages unmanagedFaster and less disruptive planned database outages. Oracle Notification Service ONS support. Global Data Services support Adds ODP. NET run time connection load balancing and fast connection failover to Oracle Data Guard and Golden. Gate. Transaction and connection association ODP. NET connections, by default, detach from transactions only when connection objects are closed or transaction objects are disposed. Version 1. 1. 2. 0. NET Framework 4. 5 certification. Entity Framework 5 certification. Version 1. 1. 2. 0. ADO. NET Entity Framework 4 and LINQ to Entities. WCF Data Services and OData. Implicit REF CURSOR Parameter Binding. Version 1. 1. 2. 0. Instant Client for Windows x. Smaller ODP. NET and xcopy installation. Times. Ten In Memory Database Support Faster ODP. NET performance through Times. Ten access. 64 bit. NET Framework 4 and. NET Framework 4 Client Profile support. Version 1. 1. 2. 0. NET Framework 4 and. NET Framework 4 Client Profile support. Version 1. 1. 2. 0. Edition Based Redefinition Allows upgrading the database component of an application while in use by. NET, thereby minimizing or eliminating down time. End to End Tracing using Client. Info attribute. Version 1. Oracle Streams Advanced Queuing API Build. NET messaging applications with Oracles database integrated queue. Promotable Transactions Promote local transactions to distributed during run time. Application Self Tuning Automatically optimizes statement cache size at run time. Faster Data Retrieval and Optimized Memory Usage. Code Access Security Enforce imperative and declarative Oracle security. High Availability Event Notification and Callback Create event handlers to respond to database status changes. Programmatic Database Startup and Shutdown. Version 1. 1. 1. 0. Instant Client Smaller ODP. NET client and xcopy installation. User Defined Types Map Oracle objects, collections, and REFs to. NET custom types. ADO. NET 2. 0 Bulk Copy Upload large data sets into Oracle from. NETProcess Database Down Events ODP. NET automatically frees connections to a downed Data Guard instance. Windows Authenticated User Connection Pooling Windows users can now use ODP. NET connection pooling. Connection Pool Performance Counters Monitor connections and connection pool status. End to End Tracing using Action and Module attributes. Version 1. 1. 1. 0. Oracle Client Result Cache Faster performance. Faster data retrieval with Secure. Files and LOBs. Improved parameter context caching for faster performance. Row Based Database Change Notification. Version 1. 0. 2. 0. NET Framework 3. 0 and 3. Configuration File Support Customize ODP. NET settings at the machine. Version 1. 0. 2. 0. ODP. NET for Windows x. ODP. NET for Windows Itanium. Local Transactions in System. Transacations. Configure Fetch. Size via Windows Registry. Version 1. 0. 2. 0. Multiple active ODP. NET Oracle Homes one active home per process. ADO. NET 2. 0 Support. Db. Common and Factory Classes. Data. Adapter Batch Update. Schema Discovery. Connection String Builder. Server Enumeration. Distributed Transactions in System. Transactions. Version 1. Server side ODP. NET for. NET stored procedures. RAC client side connection load balancing and automatic connection cleanup. Database Change Notification. LOB and LONG retrieval improvements. Faster data retrieval with no code changes needed. Initial. LOBFetch. Size can be up to 2. GBFull LOB and LONG functionality when initial fetch size is greater than zeroi. Get. Oracle. Clob and Get. Oracle. Blob methods are enabled. Connection Pool Management explicitly clear connection poolsMetadata Caching in the connection pool. Client Identifier property for supporting application context security, such as with VPDInput REF Cursor parameters. Dynamic Distributed Transaction Enlistment. Version 1. 0. 1. 0. Statement caching. Derive. Parameters automatic population of stored procedure parameters. Cancel long running queries. ADO. NET 1. 1 interfaces Has. Rows and Enlist. Distributed. Transaction properties. LOB and LONG retrieval Entire LOB and LONG column data can be retrieved even if the select list does not contain a primary key, ROWID, or unique key. Version 1. 0. 1. 0. Grid support. Schema based XMLType. BINARYFLOAT and BINARYDOUBLE datatypes. Multiple Oracle Homes. Version 9. 2. 0. 4. Improved XML DB and XMLType support. PLSQL associative arrays. Connection validation when retrieving from the connection pool. Initial. LOBFetch. Size property to improve LOB retrieval performance. New Oracle Developer Tools for Visual Studio Features by Release. Version 1. 2. 2. 0. Support for Visual Studio 2. New Oracle Database Project Version 2 project type with offline Schema Compare support. New Dependencies and References Viewer. Version 1. 2. 1. 0. Support for Visual Studio 2. New Oracle Database Project Version 2 project type with offline Schema Compare support BETA FEATURENew Update Target and Generate Script toolbar button have been added to Schema Compare. An Action checkbox in the Schema Compare output window allows partial script generation or partial target update. A Drop objects in target that are not in source option has been added to the Schema Compare Source and Target Dialog Advanced Options. Schema Compare now supports materialized views. Server Explorer menu items Generate Create Script and Generate Create Script to Project now supports materialized views, XMLType tablesviews and Index Organized Tables. Server Explorer reorganization of Tables, Views, Indexes and Triggers nodes. Version 1. 2. 1. 0. Option to enabledisable schema name usage in script generation. Cannot create an instance of OLE DB provider error as Windows Authentication user. When connecting to SQL Server with Windows Authentication as opposed to a local SQL Server account, attempting to use a linked server may result in the error message Cannot create an instance of OLE DB provider OLEDB provider name. The most direct answer to this problem is provided by Microsoft KB 2. Security settings for the MSDAINITIALIZE DCOM class are incorrect. The solution is to fix the security settings for MSDAINITIALIZE. In Windows Vista and later, the class is owned by Trusted. Installer, so the ownership of MSDAINITIALIZE must be changed before the security can be adjusted. The KB above has detailed instructions for doing so. This MSDN blog post describes the reason MSDAINITIALIZE is a COM class that is provided by OLE DB. This class can parse OLE DB connection strings and loadinitialize the provider based on property values in the connection string. MSDAINITILIAZE is initiated by users connected to SQL Server. If Windows Authentication is used to connect to SQL Server, then the provider is initialized under the logged in user account. If the logged in user is a SQL login, then provider is initialized under SQL Server service account. Based on the type of login used, permissions on MSDAINITIALIZE have to be provided accordingly. The issue dates back at least to SQL Server 2. KB 2. 80. 10. 6 from Microsoft describes the error see Message 3 and has the suggested fix of setting the In Process flag for the OLEDB provider. While setting In Process can solve the immediate problem, it may not be what you want. According to Microsoft, Instantiating the provider outside the SQL Server process protects the SQL Server process. When the provider is instantiated outside the SQL Server process. Linked Server Properties doc for SQL Server 2. R2. The better answer is to go with the Microsoft guidance and adjust the MSDAINITIALIZE security.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |