MAX in SQL return error using Microsoft OLE DB provider for ODBC drivers
I'm using ADO 2.5. My database server is Oracle 8.0.5
When I execute a query with agregate function ( MAX for example) I get an
"The Data provider or other service return an E_fail state"
This is the literal traduction of the spanish text of this error.
The following SQL return that error
SELECT MAX(Field_2) FROM AAAA WHERE 0=1
Executing directly from Oracle, this error not occurs.
Can I avoid this error without check the number of records ?
Thanks in advance
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL