dotConnect adds connection validation

Latest release adds Validate Connection string parameter to validate connections from pools.

Zoom [+]

Connecting to an Oracle database with dotConnect for Oracle.

dotConnect for Oracle offers all Oracle data types support, including Oracle XML type, and Oracle object types OBJECT, VARRAY, TABLE, REF, provides extended functionality, ability of monitoring query and stored procedures execution, advanced design-time editors.

dotConnect for PostgreSQL supports .NET Framework with ADO.NET features. To reach high performance the provider uses a native message-based protocol for communication with the PostgreSQL server.

dotConnect for MySQL can access MySQL server using native MySQL network protocol directly or through MySQL client. dotConnect for MySQL provides functionality for connecting to MySQL database, executing commands, and retrieving results. Supports the latest versions of MySQL, all MySQL data types and Embedded server.

Updates in dotConnect for PostgreSQL V5.0, dotConnect for MySQL V5.0 and dotConnect for Oracle V6.0

• Added the 'Validate Connection' connection string parameter to validate a connection from a pool
• Fixed bug with WebSite projects in Delphi Prism

Updates in dotConnect for Oracle V6.0

• Now returns error codes of SocketExceptions thrown on network errors occurring when opening direct connections
• Implemented the OracleConnection.PassParametersByName property and the 'Pass Parameters By Name' connection string parameter
• Added the 'Number Mappings' connection string parameter that allows to change default mappings of Oracle Number and Float types to .NET number types
• Fixed bug setting XMLTYPE fields of Oracle Objects
• Fixed bug creating timestamps with Timezone = 14
• Fixed bug with DbType.String parameter for long strings (>4000)

About Devart

Devart (formerly Core Lab) is a leading company working in the database connectivity area. It offers well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. Devart provides advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL and PostgreSQL database servers. It is also a vendor of powerful database tools designed to automate and simplify database development process.