| Accessing Oracle 9i Stored Procedures Using ADO.NET |
| MSDN |
| Use the .NET Oracle Provider in the Microsoft .NET Framework version 1.1 to access Oracle stored procedures and functions. |
|
| ADO.NET 2.0 Feature Matrix |
| MSDN |
| ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific. |
|
| Advanced Data Access with ADO.NET and Oracle |
| MSDN |
| Learn how to use ADO.NET 1.1 to retrieve data from complex Oracle data types. |
|
| BUG: "Invalid Property Data" Error While Creating OracleCommand in Visual Studio .NET 2003 |
| http://www.kbalertz.com/ |
| (814186) - When you create a command object for Oracle to run a stored procedure by using the OracleCommand object from the Toolbox, you may receive the following error message after you specify the stored procedure name in the CommandText property: Invalid... |
|
| Evolution of the SQL Server Programming Model from ADO to ADO.NET 2.0 |
| MSDN |
| Get an annotated overview of the data access layers that work with SQL Server, including ADO, the XML interface of SQL Server 2000 (SQLXML), ADO.NET, and the upcoming ADO.NET 2.0. |
|
| FIX: The .NET Framework Managed Provider for OLE DB may not return an Oracle error message if the locale setting is not "en-us" |
| http://www.kbalertz.com/ |
| (326722) - Explains that the .NET Framework Managed Provider for OLE DB may not return an Oracle error message if the locale setting is not "en-us". Requires that you install a hotfix to resolve the problem. |
|
| Generic Coding with the ADO.NET 2.0 Base Classes and Factories |
| MSDN |
| Learn more about the new functionality in ADO.NET 2.0 that enables you to create generic data access code. |
|
| Generic Data Provider |
| The Code Project |
| Generic Data Provider. An approach to make applications database independent. |
|
| HOW TO: Call Oracle Stored Procedures in Visual Basic .NET with the Microsoft Oracle Managed Provider |
| http://www.kbalertz.com/ |
| (321718) - This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an Input parameter, to retrieve a Ref Cursor from an Oracle stored procedure, and to display the information in a DataGrid object. Requirements The following... |
|
| HOW TO: Call Oracle Stored Procedures in Visual Basic .NET with the Microsoft Oracle Managed Provider |
| Microsoft Support |
| (321718) - This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an Input parameter, to retrieve a Ref Cursor from an Oracle stored procedure, and to display the information in a DataGrid object. Requirements The following... |
|
| HOW TO: Return an Oracle Ref Cursor to a .NET DataReader Object by Using the .NET Managed Provider for Oracle |
| http://www.kbalertz.com/ |
| (322160) - This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an input parameter to retrieve a Ref Cursor from an Oracle stored procedure by using the OracleDataReader object. Requirements The following list outlines the... |
|
| PRB: "Failed to Initialize Distributed Transactions" Error Message with Oracle .NET Managed Provider |
| http://www.kbalertz.com/ |
| (322343) - When you try to enlist an Oracle connection in a distributed transaction by using the Microsoft .NET Framework Managed Provider for Oracle, you receive the following System.InvalidOperationException exception: Failed to initialize distributed... |
|
