Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Interfaces/ODBC    [ Add a report in this area ]  
Report #:  123354   Status: Need Feedback
Add Read-Only Flag to ODBC Driver
Project:  InterBase Build #:  XE3
Version:    11.0 Submitted By:   Paul Morey
Report Type:  New Feature Request Date Reported:  3/19/2014 9:10:23 AM
Severity:    Extreme corner case Last Updated: 5/5/2014 12:58:07 AM
Platform:    All platforms Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Please add a "read-only" flag to the InterBase ODBC driver. This is important when external applications need read-only access to InterBase through ODBC so that a new transaction is not started.
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

Sriram Balasubramanian at 5/2/2014 12:36:32 PM -
Paul,
Every InterBase request needs to be executed within the context of a transaction (even if the application needs only "read-only" access).

Having said that, you can enable your ODBC DSN to have "Transaction read" checked and use this DSN in your applications needing "read-only" access to the database. This will help in optimizing database resources for that transaction.

Hope this helps.

Server Response from: ETNACODE01