I have a Oracle Package that would return an error unless I set the transaction property to 2. I have a similar package that does not return the crytic error (driver out of resources) in either mode 1 or 2. The fix is obvious (maybe), set the transaction to 2 and move on. But I just need to know - why? Both packages are simply returning cursors back to VFP of selected data. Any ideas? If you need more detail, email me. Thanks.

"Transactions Contains a numeric value that determines how the connection manages transactions on the remote table. Transactions may assume the following values:
1 or DB_TRANSAUTO (from FOXPRO.H).
1 is the default. Transaction processing for the remote table is automatically handled.

2 or DB_TRANSMANUAL (from FOXPRO.H). Transaction processing is handled manually through SQLCOMMIT( ) and SQLROLLBACK( ).
Read-Write."