Hi I only sue ODBC to connect Crystal reports and I don't use access but it occurs to me the issue is likely to be that the process takes longer in FB 3 and the access (periodically) silently times out. So you call your SQL / Stored procedure it takes longer than x seconds so access just gives up and steps to the next line of code, however the SQL is still running in FB and later completes.
I would look for timeout settings and check your SQLs execute within them. Cheers Rob On 13/05/2016 4:35 a.m., Olaf Kluge wrote: > .. and why works it sometimes and otherwhile not :( > > > > -----Ursprüngliche Nachricht----- > Von: Olaf Kluge [mailto:olaf.kl...@satron.de] > Gesendet: Donnerstag, 12. Mai 2016 18:30 > An: firebird-odbc-devel@lists.sourceforge.net > Betreff: Re: [Firebird-odbc-devel] ODBC-Problems > > Hello , > > I was just wondering why it works with the old 2.00.150 driver nearly > perfect and with the new so bad. What can I do? The Access should wait until > the record is in the table, with the earlier version this works.. > > 12.05.2016 17:48, Olaf Kluge wrote: >> Now, after we call a sp access gets not in every time the new records >> (the sp inserts for example one), only after the formular is closes >> (or the entire access), the records will be shown. > This is obviously a problem with Access transactions handling. > ------------------------------------------------------------------------------ Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
