Easysoft Data Access

Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?

odbc_num_rows is the PHP wrapper for the ODBC API SQLRowCount. $sth->rows is the Perl DBI method of obtaining the results from the ODBC API SQLRowCount.

Most ODBC drivers only return a meaningful number from SQLRowCount when you execute row changing SQL e.g. updates, deletes, inserts. For selects most ODBC drivers return -1.

Applies To

• Products
  • Easysoft ODBC-Oracle Driver
  • Easysoft ODBC-InterBase Driver
  • Easysoft ODBC-Sybase Driver
  • Easysoft ODBC-ODBC Bridge
  • Easysoft ODBC-Firebird Driver
  • Easysoft ODBC-ISAM Driver
  • Easysoft ODBC-Zortec System Z Driver
  • Easysoft ODBC-ODBC Join Engine
  • Easysoft ODBC-RMS Driver
  • Easysoft ODBC-CODA Driver
  • Easysoft ODBC-SQL Server Driver
  • Easysoft ODBC-Access Driver
  • Easysoft ODBC-DB2 Driver
  • Easysoft ODBC-Derby Driver
  • Easysoft ODBC-Salesforce Driver
  • Easysoft ODBC-MongoDB Driver
  • Easysoft ODBC-Google Analytics Driver
  • Easysoft ODBC-MySQL Driver
  • Easysoft ODBC-QuickBooks Desktop Driver
  • Easysoft ODBC-PostgreSQL Driver
• Interfaces
  • ODBC
• Languages
  • PHP
  • Perl
  • C

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2023 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•