[Firebird-odbc-devel] ODBC-Problems

[Olaf K. <ola...@sa...>]

Hello,

 

after we updated the fb odbc driver to 2.04 we have some problems. The
frontend is ms access, the tables are linked to firebird and one
adodb-connection (every time closed) calls stored procedures.

 

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. 

 

The old driver 2.00.150 (rc2) works better and faster but since fb 3 I get
an error during linking to the tables. Are the tables already linked it
works fine.

 

One problem more: We insert in Access a new record in the main-table, after
this we go in the ufo (position-table) and everythin is fine, in the second
table the reference (year and number) to the main-entry will set. But if we
call an stored procedure which inserts this record (special function) and
after this we klick to a new record, the given ID (number) is wrong (ID from
the insert of the stored procedure). After we klick a second time in the
formular, the right number will be shown and the error is not present. The
ID will generated with a generator (trigger) in firebird.

 

Thanks for helping.

 

Best regards.

 

Olaf