Easysoft ODBC-ODBC Bridge

Why doesn't a query return recently inserted data?

The issue reported to us is: "INSERT statements seem to work OK and an immediate SELECT with the same cursor works to display the data, but when I retry the query the data is gone."

Some ODBC enabled languages have autocommit set to off by default.

There are two options to ensure that INSERT statements are committed to the database.

1. Ensure that the relevant autocommit flag is switched on in your connection.
2. Use appropriate commit and rollback methods in your script.

See the following resources for detailed information on how to do this in individual languages:

• Python
  • mxODBC

    (http://www.egenix.com/products/python/mxODBC/)

  • pyodbc

    (http://pyodbc.sourceforge.net)

• perldoc DBI or Perl

  (http://dbi.perl.org)

• PHP

  (http://www.php.net)

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge

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)

• 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 - 2024 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.

• 
• 
• 
•