Neoview ADO.NET Provider Manual HP Part Number: 617725-001 Published: July 2010 Edition: Release 2.
© Copyright 2010 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents About This Document.........................................................................................................7 Supported Release Version Updates (RVUs)..........................................................................................7 Intended Audience.................................................................................................................................7 New and Changed Information in This Edition.............................................
List of Tables 3-1 3-2 3-3 3-4 3-5 3-6 3-7 3-8 3-9 3-10 3-11 3-12 3-13 3-14 3-15 3-16 4 Connection String Properties........................................................................................................15 Delimiting Special Characters in a Connection String .................................................................16 Catalog Column Names................................................................................................................17 Catalog Restriction Names......
List of Examples 3-1 3-2 Example Tracing Output...............................................................................................................21 The Configuration File for Neoview Tracing................................................................................
About This Document This document describes how to use the HP Neoview ADO.NET Provider to access HP Neoview SQL databases on the HP Neoview Data Warehousing Platform for Business Intelligence. Installation instructions are included in README for the HP Neoview ADO.NET Provider. Supported Release Version Updates (RVUs) This manual supports Neoview Release 2.5 and all subsequent releases, until otherwise indicated in a replacement publication. Intended Audience This Neoview ADO.
• Management HP Database Manager (HPDM) Help topics that describe how to use the HP Database Manager client to monitor Online Help and manage a Neoview data warehousing platform. HP Database Manager (HPDM) Information for database administrators about how to monitor and manage User Guide a Neoview data warehousing platform using the HP Database Manager. Neoview Command Interface (NCI) Guide Information about using the HP Neoview Command Interface to run SQL statements interactively or from script files.
Neoview Messages Manual Cause, effect, and recovery information for error messages. README for HP Neoview Release 2.5 Information about new features for the current release, including where to download software and obtain documentation. Related Information Information about ADO.NET can be found at these web sites: • http://msdn.microsoft.com/en-us/library/e80y5yhx(VS.80).aspx • http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx • http://msdn.microsoft.com/en-us/library/system.data.common.
1 Introduction to ADO.NET ADO.NET Support for Neoview The HP Neoview ADO.NET Provider is the Neoview implementation of a set of software components included in the Microsoft .NET Framework. You can use the ADO.NET implementation for data source connectivity and to access and manipulate data in a Neoview SQL database.. NOTE: The Microsoft .NET Framework must be installed before you can use ADO.NET. See the README for the Neoview ADO.NET Provider for details about installing ADO.NET. ADO.
2 Neoview ADO.NET Compliance The Neoview ADO.NET provider is fully compliant with the ADO.NET specification defined by Microsoft. The standard interfaces defined in the System.Data.Common namespace are implemented for HP Neoview: • Connection • Command • DataReader • DataAdapter • Transaction • CommandBuilder • ConnectionStringBuilder • Parameter • Exception • ProviderFactory For more information about the ADO.NET standard interfaces, see: http://msdn.microsoft.com/ en-us/library/system.data.common.aspx.
3 ADO.NET for Neoview The Neoview ADO.NET provider conforms where applicable to the Microsoft ADO.NET specification. The Neoview ADO.NET provider differs from the standard in some ways, and has these Neoview-specific implementations for connection strings and schemas: • • • “Neoview ADO.NET Connection String” (page 15) “Neoview Schema Collections for ADO.NET ” (page 16) “Restrictions and Extensions of ADO.NET Methods and Properties for the Neoview Platform” (page 19) Neoview ADO.
Table 3-1 Connection String Properties (continued) Name Default Description IdleTimeout 600 Number of seconds of idle time, after which the client is disconnected FetchBufferSize 4096 Kilobytes of memory to allocate for the server-side data buffer ApplicationName N.A. The application name Example: MyApplication Delimiting Special Characters in a Connection String Special characters in the connection string, such as spaces or semicolons, must be used with delimiter, or quoting, characters.
• • “Columns” (page 18) “PrimaryKeys” (page 19) Wildcards in values are allowed, per the ADO.NET specification. For example, given this list of objects: SEE, SAP, SEED, SED, and TABLE: • S* returns SEE, SAP, SEED, SED • S__ (S and two underscores) returns SEE, SAP, SED • S*ED returns SEED, SED For detailed information about the common schema collections and the getSchema() method, as defined by Microsoft, see http://msdn.microsoft.com/en-us/library/kcax58fh(v=VS.90).aspx .
Views Table 3-9 View Column Names Column Name Data Type Description CatalogName String Name of the catalog SchemaName String Name of the schema ViewName String Name of the view Table 3-10 View Restriction Names Restriction Name Data Type Description CatalogName String Pattern used to restrict the CatalogName SchemaName String Pattern used to restrict the SchemaName ViewName String Pattern used to restrict the ViewName Column Name Data Type Description CatalogName String Name of
Table 3-14 Column Restriction Names Restriction Name Data Type Description CatalogName String Pattern used to restrict the CatalogName SchemaName String Pattern used to restrict the SchemaName TableName String Pattern used to restrict the TableName ColumnName String Pattern used to restrict the ColumnName PrimaryKeys Table 3-15 PrimaryKeys Column Names Column Name Data Type Description CatalogName String Name of the catalog SchemaName String Name of the schema TableName String Name
Clarifications • • The DataSource property returns the server data source name (that is, TDM_Default_DataSource). The Database property and the ChangeDatabase method are equivalent to getting or setting the current catalog in Neoview. Currently, the only catalog available is NEO. Limitations • • The Neoview platform does not support multiple transactions on a single connection. If BeginTransaction is called when there is already an active transaction, ADO.NET Provider throws an exception.
NOTE: Tracing can help you solve problems you might encounter. However, enabling tracing does increase system overhead, depending on the message types and settings you select.
For information about the .NET System.Diagnostics.Trace framework, see http:// msdn.microsoft.com/en-us/library/system.diagnostics.trace(VS.71).aspx Property type: Boolean Value: True | False NOTE: Setting this property to an invalid value disables tracing output to the console. Specifying a File for Tracing Output — NeoviewTraceFile Use the NeoviewTraceFile property to indicate the file to receive tracing output. One global trace file is used per application.
Index NeoviewTraceConsole, 21 NeoviewTraceFile, 22 NeoviewTraceLevel, 21 Symbols .NET Framework, 11 A S ADO.NET error messages, 22 overview, 11 requirements, 11 schema collections, 16 special characters in connection string, 16 quoting, 16 C T configuration file example, 22 Connection string, 15 connection string required properties, 15 special characters in, 16 connectivity ADO.