Actian Community Blogs

Ingres Connectivity continues to evolve. The following enhancements are planned for Ingres 10.1:

• ODBC Batch Execution – Execution of a single query with arrays of parameters
• JDBC getGeneratedKeys Enhancement
• .NET Data Provider support for Connection string Identifier_Delimiter = Bracket to allow the provider to recognize both double quotes and brackets for delimited identifiers
• .NET Data Provider support for batch updates via the DbDataAdapter.UpdateBatchSize property

For more...

Many of you are just beginning to consider migrating from Ingres 9.2 and earlier releases and may be unaware of the many new features included in the Ingres Connectivity area since 9.2. I will be writing a series of blogs that details the changes in the protocol drivers, JDBC, ODBC, .NET, and OpenAPI since Ingres 9.2. These features are also applicable to Vectorwise unless otherwise noted.

• Network Protocol Drivers/Authentication Enhancements
• JDBC
• ODBC
• .NET
• OpenAPI

Conclusion...

.NET Data Provider version 2.1.xxxx.24, where xxxx is 930, 1000, or 1010, introduced in Ingres 9.3, provided the ability to target the Multiple Data Access Servers functionality added in Ingres 9.3. A .NET Data Provider client may target a connection to multiple Data Access Servers by providing a list of ports in the IngresConnection.ConnectionString connection :
or
...

Ever wonder how to find more information on the Ingres .NET Data Provider? There is quite a bit of information on the Ingres Community Wiki relating to the Ingres .NET Data Provider and using .NET with Ingres.

Most of this information is centrally located at Ingres .NET Development Center. We try to ensure all content on the wiki related to .NET and Ingres can be accessed from this main page. I’m sure we don’t manage to link up everything but we do try.

A summary...